SQL Queries

 use classicmodels;

select * from customers;

select count(distinct customerNumber) as unique_customer_number

from customers;

select count(distinct customerNumber) as unique_customer_number,country

from customers

group by country;

select * from customers

order by customerNumber

limit 10;

select * from customers

order by customerNumber desc

limit 10;

select * from employees;

select firstName,jobTitle

from employees;

select jobTitle,count(firstName) as count_name

from employees

group by jobTitle;

select jobTitle,count(firstName) as count_name

from employees

group by jobTitle

order by count_name desc;