The query is supposed to output the total number of products that cost more than 9.99. ( use... >, where, from, price)

 

2-Write a query to display the first_name and last_name of all records in the contact table

 

3-Write a query to display the full_name of records in the contact table with full_name of Smith anywhere in the field.

 

4-Write a query to display the first_name and last_name of records in the contact table with the last_name of 'Smith' (exact matches only).

 

5- I need  a query to display all fields in the contact table and only those records with last_name starting with the letter A.
SELECT

 

6- Write a query to display the first_name and last_name of all records in the contact table sorted alphabetically by last_name.

 

7- Write a query to display the last_name, email and city_name of records in the contact and zip tables where the city_name is 'Birmingham'. You must use an inner join (your choice of ON or USING join syntax). The field zip_code is common to both tables, and city_name is in the zip table.

 

8- Write a query to display the average price of a movie (output/alias the field as avg_price) from the film table. Your query should only have a single column as output. Note that you can get the average of a field using the AVG() function. Example for average of length: AVG(length)

 

9- Write a query to display the list of all movie titles (title) and prices (price) from the film table, with a production_date on or before '2011-02-01', sorted by production_date from newest to oldest.
Note that date comparison is basically the same comparing numbers, so can use >, <, =, <=, >=, etc. -- but keep the quotes around the date.