Question: ref : https://www.chegg.com/homework-help/questions-and-answers/homework07-sql-joins-must-use-join-following-queries-assignment-asked-create-several-sql-q-q32496935 Instructions on how to submit : Write a query for each of the questions below in a word document. I should be

ref : https://www.chegg.com/homework-help/questions-and-answers/homework07-sql-joins-must-use-join-following-queries-assignment-asked-create-several-sql-q-q32496935 Instructions on how to submit : Write a query for each of the questions below in a word document. I should be able to copy that query. Run the statement, take a screenshot of the answer, and attach it to the document. Make sure to add your name to the screen (type it on the workbench editor) while taking the screenshot, so I know that you wrote the query and executed it. Also mention the number of rows you get for the answer. Use Sakila schema for the questions below. Q1) Write a query that produces the first_name, last name, address, district, and postal code for all customers. (Append to customers the information from the adress table.) (LEFT JOIN) Q2) Write a Query that produces address, district, a city for all addresses. Q3) Write a Query that tells you how many cities are there for every district. Q4) Write a query that produces the title, rental rate, and language for all Action and Comedy films. (3 Inner joins) Q5) Write a query that produces film title, description, and category for all films. (Inner Join)

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!