SQL Fundamentals

…

Lab5 objectives100 XP

02.Count Rows and Values

Each answer is one row with one number. Let the database count: do not count the rows yourself.

How many customers does the shop have?
How many customers have an email?
Think before you run it: what does SELECT COUNT(city) FROM customers; return?
How many different countries do the customers come from?
How many orders have the status pending?

Something unclear, wrong or missing?

Databaselab-db · PostgreSQL in your browser 0:00

SELECT * FROM customers;

Ctrl↵runs the query · select text to run part of it

Objective 1 of 50/5 done

Count the customers
One row, one column.