Which of the following queries creates a Cartesian join?(refer to the tables in the JustLee Books database.)a. SELECT title, authoridFROM books, bookauthor;b. SELECT title, nameFROM books CROSS JOIN publisher;c. SELECT title, giftFROM books NATURAL JOIN promotion;d. all of the above

Write an SQL query that will select OrderID and OrderDate from theOrders table and OrderDetailID from the OrderDetails table. The queryshould join on the Orders table using the OrderID attribute.

Given the following query:SELECT DISTINCT zip, categoryFROM customers NATURAL JOIN orders NATURAL JOIN orderitemsNATURAL JOIN books;Which of the following queries is equivalent? (refer to the tables in the JustLee Books database.)a. SELECT zip FROM customersUNIONSELECT category FROM books;b. SELECT DISTINCT zip, categoryFROM customers c, orders o, orderitems oi, books bWHERE c.customer# ¼ o.customer# AND o.order# ¼ oi.order#AND oi.isbn ¼ b.isbn;c. SELECT DISTINCT zip, categoryFROM customers c JOIN orders oJOIN orderitems oi JOIN books bON c.customer# ¼ o.customer#AND o.order# ¼ oi.order#AND oi.isbn ¼ b.isbn;d. all of the abovee. none of the above

Which type of join is demonasted by the folloing query? Select from make. model where make modelID to mode ID a) Non-Equlion b) Self Join c) Cross Join d) Equijoin

Write the following as MySQL query: Find the employee ID, first and last name, and salary for each employee whose salary ismore than $20,000 or who works in the shipping department. Use the UNION set operator. List the country ID, country name, city, and state/province. Be sure all country names areincluded in the result, regardless of whether there is no matching city and state/province. You have to use an outer join.

Emp:- Id is Primary keyProject:- EmpId foreign key.Find out the output of the left outer join, right outer join and inner join.Take the below columns in output:-Emp table ID, name.Project table projectID, NAME

Write a SQL query to find the customer# of those customers that purchased at least once in July 2020 but NOT in August 2020. In addition to the customer#, show the ISBN and title of the book(s) they purchased in July 2020. You may use only one query. No creating any temporary tables or subqueries. You may use only joins. SUBMIT a second solution in addition to your Level 1.

What is the difference between a subquery and a JOIN?

Which type of constraint can be used to make certain the category for a book is included when a new book is added to inventory? ( refer to the tables in the JustLee Books database).

2. Create a SELECT statement that returns the ORDER_NUM and PROD_ID for all records in the ORDERITEMS table. Using inner joins include the vendor name, product name and customer name for each item.