CustomerName, ContactName, Address, City, PostalCode, Country) VALUES (‘Cardinal,”Tom B. Erich

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.

using the code below write a query to display the minimum balance, maximum balance, and average balance for memberships that have a rental CREATE TABLE MEMBERSHIP ( MEM_NUM                   NUMBER(8,0) PRIMARY KEY, MEM_FNAME   VARCHAR2(30) NOT NULL, MEM_LNAME   VARCHAR2(30) NOT NULL, MEM_STREET  VARCHAR2(120), MEM_CITY                   VARCHAR2(50), MEM_STATE    CHAR(2), MEM_ZIP                     CHAR(5), MEM_BALANCE           NUMBER(10,2) ); CREATE TABLE RENTAL ( RENT_NUM      NUMBER(8,0) PRIMARY KEY, RENT_DATE     DATE DEFAULT SYSDATE, MEM_NUM       NUMBER(8,0) CONSTRAINT RENTAL_MEM_NUM_FK REFERENCES MEMBERSHIP ); INSERT INTO MEMBERSHIP VALUES (102, 'TAMI', 'DAWSON', '2632 TAKLI CIRCLE', 'NORENE', 'TN', '37136', 11); INSERT INTO MEMBERSHIP VALUES (103, 'CURT', 'KNIGHT', '4025 CORNELL COURT', 'FLATGAP', 'KY', '41219', 6); INSERT INTO MEMBERSHIP VALUES (104, 'JAMAL', 'MELENDEZ', '788 EAST 145TH AVENUE', 'QUEBECK', 'TN', '38579', 0); INSERT INTO MEMBERSHIP VALUES (105, 'IVA',…

Create a query that lists the department number, employee number, and salaries of all employees in department D11.    UNION the same information , but this time sum up all the salaries to create a one line summary entry for the D11 department (hint sum the salary). Sort the list by Salary.

Select all rows from the Orders table where the CustomerID is greater than 300.

Run a query or multiple queries if needed to report on final exam average based on thestudent’s age. Give an average for all students 40 and below and an average for all studentsover 40. This report will be used continuously so you cannot just figure out what 40 years agotoday was. You need to use the date to calculate their age somewhere in your solution