MYSQL Sample Database Diagram productlines *productLine textDescription htmilDescription image products orderdetails productCode productName productLine productScale productVendor productDescription quantitylnStock buyPrice orderNumber productCode quantityOrdered priceEach orderLineNumber employees * employeeNumber lastName MSRP orders firstName orderNumber extension orderDate email customers officeCode reportsTo jobTitle requiredDate shippedDate status customerNumber customerName contactlastName contactFirstName phone comments customerNumber offices addressLine1 addressLine2 officeCode city phone addressLine1 addressLine2 state country postalCode territory city payments customerNumber state postalCode country salesRepEmployeeNumber checkNumber paymentDate creditLimit amount

List all the names of the production companies and all the movie titles, all together in one single column in the result set. Sort the result column alphabetically. For example, the first row will be Abominable, the second row will be Cars, the third row will be Columbia Pictures, and so on. use sql ( so there a table of 'movie' and a table of 'production')

Write an SQL query using the IN operator to show all customers residingin the following zip codes: 91508, 91510, 33111

Write an SQL query that will show all data from the Customers table andOrder By State.

Do a SQL query using their data format to see who hasn't attended any classes there. Please avoid using set operations and subqueries (use an outer join).

Write an SQL query using the AND operator that show all orders shoppedon April 1, 2009 shipped to the state of Florida

Write the full sql query including (create,insert,select...) please

How do you compose a subquery in SQL where you are searching for the most common value in one column for a specific value from another column (i.e. looking for the down where most penalties occur --> down is a column and PlayType is a column with penalties as a value). The columns are in the same table.

Write an SQL query using the UPDDATE and SET operator that willoverwrite all values containing 16 with 32 in the SupplierID attribute inthe Products table.

Write a query in SQL code for: "List the book categories and the average book price of each category."  Tablename is "BOOKS" and column names are: ISBN TITLE PUBDATE PUBID COST RETAIL DISCOUNT CATEGORY