Question: i need the SQL queries. - Find the last name of employee whose job title is 'VP Sales'. - Find the names of employees (last

i need the SQL queries.

- Find the last name of employee whose job title is 'VP Sales'. - Find the names of employees (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 total order quantities))

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!

Instructions: Depending on your Excel skill level, you may find this assignment challenging 1. This assignment is from Extended Learning Module D in your textbook. Locate the chapter, and review the...

For the Pizza Delivery Shop DB, (see Appendix), write SQL queries to answer each of the following questions. a) List all the last names, phone numbers and zip codes of the customers. b) List...

Problem 2 - For the following problems screenshot your code and output (View) Grading Rubric: (Total 50 points) 5 points for each question 1 point for posting view and output correctly 4 points for...

SQL 1. Display the last name and current job title of each employee, along with the department name they are currently working in. Label the columns "LAST NAME", "JOB TITLE", and "DEPARTMENT". . 2....

[/ : ] Taye3 Albeek: 1. Produce a list of employees for jobs IT_PROG, SA_REP and ST_CLERK, in that order. Display last_name and job_id using set operators. 2pt [/ : ] Taye3 Albeek: 2. Display the...

Read the fact pattern for the assignment. Then answer the questions. The first section asks for you to analyze ethical issues related the case. The second part applies employment law issues. Be sure...

I found it on chegg the answers but they have plagiarism? please ? it is very helpful if its own your own answer without other source ? thank you Nuts \& Bolts Inc. is a manufacturer of industrial...

LOCATIONS location id street address postal_code HR DEPARTMENTS department id location_id JOB HISTORY state province country id employee id start date end date job id department id EMPLOYEES employee...

How can I write SQL query of the Access of the Microsoft about select, from, where, etc.? Simple Selection (Columns) 1. Get a complete list of employee names and addresses. Do not show any irrelevant...

Compare the growth rates of input, output, and multifactor productivity in Japan and the United States since 1970.

Select an organization or industry you are familiar with. Identify and list 1 each of the following. Events or conferences for your selected organi z ation or industry

who does not qualify as dependent on parents in terms of the 8 ncome tax act?

Festion 2 Case No. 1:19) marks) 9 points Read the following case and use your knowledge, skills, and critical thinking to answer the questions below. You work as CFO of Asian Company which has great...

LAST WORD Suppose Winter Sportsa hypothetical French retailer of snowboardswants to order 5000 snowboards made in the United States. The price per board is $200, the present exchange rate is 1 euro ...

Exports pay for imports. Yet in 2005 the nations of the world exported about $724 billion more worth of goods and services to the United States than they imported from the United States. Resolve the...

KEY QUESTION Diagram a market in which the equilibrium dollar price of 1 unit of fictitious currency zee (Z) is $5 (the exchange rate is $5 Z1). Then show on your diagram a decline in the demand for...