Question: Task 2 : Run SQL queries to answer the following questions. Find the last name of employee whose job title is ' VP Sales'. Find

Task 2: Run SQL queries to answer the following questions.
Find the last name of employee whose job title is 'VP Sales'.
Find the names of employes (last name, first name) whose offices are in 'San Francisco'.
Find the names of customers (last name, first name) who purchased 'Classic Cars' according to the productLine feature of the products.
Find the productName of products which has the highest MSRP price.
Find the last names of the customers who have made 5 or more payments.
Find the most popular productLine (which means that it was purchased the most (maximum number of order)
 Task 2: Run SQL queries to answer the following questions. Find

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!