4. Which customers live in Georgia or New Jersey? Put the results in ascending order by last name. List each customer’s customer number, last name, and state. Write this query in two different ways

Using SQL determine salary is above 4000 and job_id starts with a letter “S”  In addition, when grouping the above selected employees by department, we only show the department which has more than 5 employees or the minimal salary greater than 5000, and order the result by the average salary.

Write a query that returns the EMP_NUM and Number of ratings he/she earned (based on EARNEDRATING table, call this Num_RTG), for those who had at least got 1 rating earned, but the number of ratings he/she earned must lower than the average number of ratings for all employees who had earned ratings before, and such employee has been served as “Copilot” before.

5. Determine the profit of each book sold to Jake Lucas, using the actual price the customerpaid (not the book’s regular retail price). Sort the results by order date. If more than onebook was ordered, sort the results by profit amount in descending order. Perform thesearch using the customer name, not the customer number.

Management is considering closing on Sundays and would like to have a feeling for the kinds of customers that come to the dealership on Sunday. Create a totals query that shows the count of encounters on the Sundays of July 2015—grouped by the credit description held by the customer of the encounter. The Sundays in July of 2015 are the 5th, 12th, 19th, and 26th. Your answer should have two columns (CreditDescription and encounter_count) and should be sorted alphabetically by credit description.  This is what Ive been working with and doesn't give me results, just error messages.  SELECT R.CreditDescription, E.CustomerID FROM Encounter E JOIN Customer C ON E.CustomerID = C.CustomerID JOIN CreditRating R ON C.CreditID = R.CreditID WHERE E.EncDate = STR_TO_DATE('2015-07-05','2015-07-12','2015-07-19','2015-07-26'); ORDER BY creditrating.creditid, ASC;   creditrating creditid creditdescription minfico maxfico comments customer customerid cfirstname clastname…

Write a query to list the book title, checkout date, checkout due date and checkout in date for each book.

From the following query, identify the value of City: INSERT INTO Customers ( CustomerName, ContactName, Address, City, PostalCode, Country) VALUES (‘Cardinal,”Tom B. Erichsen”,”Skagen 21”, “Stavanger,” “4006Norway’);

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 to determine how many products you can find in the Production.Product table. This is an SQL Table.

Write a query that displays the book title, cost, and year of publication for every book in the system. Sort the results by book title.