Question: Please read carefully! Create SQL statements for each of the following. Make sure to test each file (using the Parse button) before executing it. When


Please read carefully! Create SQL statements for each of the following. Make sure to test each file (using the Parse button) before executing it. When you are done, copy and paste all of your SQL statements into a single query window in SQL Server. Make sure the statements are in the same order as the questions listed here, and save your work as a.sql script. Submit your sql script on TITANium. 1. Write an SQL statement to list all columns for customers with a Seattle address. 2. Write an SQL statement to list all cities where customers live. Make sure the result does not include duplicates. 3. Write an SQL statement to list the first and last name of all employees who have the last name of Stuart or the first name of John. 4. Write an SQL statement to list the item description and item cost of all items with a cost between $595 and $705. 5. Write an SQL statement to list the company names and fax numbers of all vendors who have a fax number listed in the table. Sort the result in descending order by company name. 6. Write an SQL statement to list the minimum, maximum, and average item price of all items with an item cost greater than $2000. 7. Write an SQL statement to count the number of items that have a price above $4000. 8. Write an SQL statement to list the item description of all items whose description starts with "Antique
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
