The query is supposed to output the total number of products that cost more than 9.99. (
Fantastic news! We've Found the answer you've been seeking!
Question:
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.
Related Book For
Concepts of Database Management
ISBN: 978-1285427102
8th edition
Authors: Philip J. Pratt, Mary Z. Last
Posted Date: