Question: sql project help sorry I got a better picture of it now ** Please consider om database. [2 pt] 1. Write a SELECT statement to

sql project help
"sorry I got a better picture of it now"
** Please consider om database. [2 pt] 1. Write a SELECT statement to display everything in the table customers. [3 pts] 2. Write a SELECT statement to list the order id and the order date from the table orders. Filter your result set to include only records for the orders placed in July or in April for the year 2014. [5 pts] 3. Write a SELECT statement to display only the customers with a zip code that starts with 4 and ends with 2 or their state is OH. [5 pts] 4. Write a SELECT statement that joins customers table to orders table and returns the columns: customer id, customer first name, customer last name, customer phone, order date, shipped date. Include only customers having an order. Use alias for tables. Filter your result to include only customers from the state CA. Sort the result set to show recent shipped orders first. [6 pts] 5. Write a SQL query to display the orders not yet shipped. [4 pts] 6. Write a Select statement that returns all orders for the same customer. [5 pts] Formatting: [5 pts] Include your details at the top (Name, Student Id and your Section) Comment your code Include the questions header Follow the SQL standards Clarity of your code (proper font size)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
