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 cphone annualincome creditid   encounter encid salesid customerid encdate purchase   salesperson salesid sfirstname slastname shiredate salary

Q: List unique first (first_name) and last names (last_name) of customers (CUSTOMER table) who rented a…

A: In this question, we are asked to write a SQL query to fetch the unique first and last names who…

Q: Write a query to list the book number, title, and number of times each book has been checked out…

A: Query The query for viewing book number, title and the number of times each book had been checked…

Q: Create a query for displaying average commission percentage company is giving to its employees.…

A: Format of Query :- SELECT AVG ( coloum name ) AS aliasname FROM tablename; According To question :-…

Q: sql query

A: Here have to determine about SQL query for given scenario.

Q: Employee_id          Name          Salary 1001                         Annie           6000 1009…

A: SELECT * FROM employee WHERE employee_id>1009   employee_id will be 1018 And output will be…

Q: Your company needs to contact the 1st author of each textbook and to discuss reprint options. Pull…

A: Microsoft AccessMicrosoft Access is a relational database management system that allows you to…

Q: Write a query to display the patron ID, first and last name of all patrons that have never checked…

A: Answer 1:- Query to copy : select PAT_ID, PAT_FNAME, PAT_LNAME from PATRON where PAT_ID not in…

Q: SELECT name FROM instructor WHERE salary = 90000; This query can be replaced by which of the…

A: In the given sql query, the "instructor" table is used. But in option b and option c, employee table…

Q: using the code write a query to display the movie number, movie title, movie cost, and movie genre…

A: 1. Create a table named MOVIE:   - Define columns:     - MOVIE_NUM as INT (Primary Key)     -…

Q: Write a query to display the checkout number, book number, patron ID, checkout date, and due date…

A: The query follows the syntax given below. SELECT column1, column2 FROM table1 WHERE condition ORDER…

Q: Create a student table. The student table needs to include the following columns: Student ID Student…

A: SQL queries are a set of instructions given to the database to retrieve specific data. SQL was…

Q: In an ORDER BY clause, what are the two ways to refer to the columns to be used for sorting the…

A: Question :- In an ORDER BY clause, what are the two ways to refer to the columns to be used for…

Q: The InstantRide Finance team also wants to analyze travels where more than the average discount rate…

A: Since you have not specified the table name , let  us assume that the data is present in TRAVELS…

Q: The Colombia City office of StayWell indicated that there is a new tenant by the name of Yigit…

A: Here, the new record has to be added to a table and this process is called as Insertion and the…

Q: Write a query to display the patron ID, book number, and days kept for each checkout. “Days Kept” is…

A: below are the two commands that you can try: 1.   Select PATRON.PAT_ID, BOOK.BOOK_NUM,…

Q: Create a stored procedure called sp_shipping_date where the billing date is equal to the order date…

A: Given   create procedure sp_shipping_date (@billing_date datetime) as select Orders.OrderID,…

Q: Selecting Multiple Columns When buying food, it is important to make sure it is fresh and not…

A: Answer to the given question The query to select the ProductName, ProductionDate and ExpirationDate…

Q: Write a query to display the last name, job of all employees whose last names starts with the letter…

A: Query - A database query is a request for information from a database. It is a statement that is…

Q: database HR Write a query to display the last name, job, department number, and department name for…

A: COMMANDS: SELECT command: The select command is basically used for the purpose of selecting the…

Q: Write SQL CODE List the Professor's First (EMP_FNAME) and Last names  (EMP_LNAME) of those who teach…

A: Non correlated subquery They are typically used to improve the performance of a query by executing…

Q: Write a query to display the book number, title, and number of times each book has been checked out.…

A: SELECT CHECKOUT.Book_Num, Book_Title, COUNT(*) 'Times Checked Out' FROM BOOK LEFT JOIN CHECKOUT ON…

Single Table

In a database management system, a single table is designed to obtain data of heterogeneous items. A single-table design with DynamoDB resolves the issue of raising multiple requests for the relevant data of an entity.