COVER PAGE. Task 1. My Database select queries . Write

COVER PAGE

Task 1
My Database select queries
 Write a query that uses an aggregate function.
select count(customerid) from customer;

Write a query that retrieves data from at least two of your tables.
select customer.*, address.* from customer,address where
customer.customerid=address.customerid;
 Write a query that has a primary and secondary sort. One of the sorts must be in the reverse
order.
select customer.*, address.* from customer,address where
customer.customerid=address.customerid
order by customer.firstname desc,address.street;

 Write a query that implements a wildcard search.
select * from customer where lastname like '%n%';
 Write a query that uses a mathematical calculation to on two or more columns and uses a
column alias on the calculation.
select max(customerid)-min(customerid) as "Difference between the first and last
customerid" from customer;