local host mayb keep losing dataso you need to go dbeaver and invalidate /reconnect
also you can replace localhost with 127.0.0.1 or with the assigned ip address.
this will help when there is no localhost and need to use the database within the local network or host.
the port where the db is running
by default postgress 5432
assignment is on
- Host: 172.178.131.221
- Port: 5432
- Database: warehouse
- User: luxds
- Password: 1234
- Schema: dataanalytics
- Table: international_debt https://neon.tech/postgresql/postgresql-administration/psql-commands
select * from datanalytics.international_debt
select count(*) from dataanalytics.international_debt
;
github repository containinng sql scripts plus and article for intro to sql for data analytics...
harun mbaabu
22:27
SQL STATEMENT TO CHECK NUMBER OF ROWS?
Elijah Mwangi
22:28
Select count();
dancan Kombo
22:28
select count() from dataanalytics.international_debt
You
22:29
select count(*) as row_counts from analytics.internationa_debt
harun mbaabu
22:29
1). What is the total amount of debt owed by all countries in the dataset?
harun mbaabu
22:31
2). How many distinct countries are recorded in the dataset?
3). What are the distinct types of debt indicators, and what do they represent?
4). Which country has the highest total debt, and how much does it owe?
5). What is the average debt across different debt indicators?
6). Which country has made the highest amount of principal repayments?
7). What is the most common debt indicator across all countries?
8). Identify any other key debt trends and summarize your findings
markdown, push the changes to github,
Top comments (0)