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 : 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 or more payments.
Find the most popular productLine which means that it was purchased the most maximum number of order
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
