Make a list of salespeople who made no sales on a Monday (Hint: your answer to question 1 is a good starting point).

Q: 10. When we find out that there are some miss spellings in the query?

A: Given: Where did we discover certain misspellings in the SQL query?

Q: Second normal form says:   a. No nonkey columns depend on another nonkey column.   b. Every…

A: The second normal form says:   a. No nonkey columns depend on another non-key column.   b. Every…

Q: CUSTOMER Customer table is composed of customer number, name and phone number. Give and fill-in the…

A: Answer:- Atrributes: It is a column in a table Table CUSTOMER: Atrributes : 1.custID( Type),…

Q: List all book titles that have never been borrowed by any borrower.

A: The SQL program for the given problem is as follows: use demo;Create table Book(ISBN varchar(30) Not…

Q: mysql> select * from item_db; | item_code | item_name 2 B 8 10 33 85 200 500 9 6 rows in set (0.00…

A: The number of orders made for the item with code '200' directly from the provided item_db table.…

Q: Write a SELECT statement that joins the Departments, Courses, and Instructors tables. This statement…

A: To achieve this using a SQL SELECT statement with JOIN operations, filtering for courses with three…

Q: Create the following table in your database with the following schema: Table: Users +- | Column Name…

A: create table Users(id int, name varchar(10),primary key (id)); insert into Users values(1, "Alice");…

Q: Who has rented movies in Japanese language? Return only the first five distinct results in…

A: The INNER JOIN keyword chooses records from both tables whose values match. The SELECT clause just…

Q: Write a SELECT statement that joins the Instructors and Courses tables and returns these columns:…

A: To accomplish this task, you can use a SQL SELECT statement that performs a LEFT JOIN between the…

Q: You need to return all travel data from the TRAVELS table for the CAR_ID which has a plate number…

A: Here, you need to join both the tables with same car_id whose car_plate is BB-883-***

Q: 5. Add a column to the query described in exercise 2 that uses the RANK() function to return a…

A: The above question is solved in step 2 :-

Q: Task 6: Find the ID, first name, and last name of each customer for which an invoice was not created…

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

Q: Determine which orders had a higher total amount due than order 1008.

A: Explanation: The following query determines the orders where the total amount is higher than order…

Q: Task 1: The Finance team wants to calculate a VAT (8%) on the amount of the stay reservations in the…

A: An SQL prepared code that may be saved and reused repeatedly is known as a stored procedure. So, if…

Q: Write a SELECT statement that returns two columns based on the EMPLOYEES table. Contact, is the…

A: SELECT CONCAT(LastName," ",substring(FirstName,1,1)) as CONTACT, HomePhone as Phone FROM EMPLOYEES…

Q: Display the last name, salary, and commission for all employees who earn commissions. Sort data in…

A: In the above question, needs to find out only those employee's last name, salary, and commission who…

Q: Task 4: The InstantRide User Satisfaction team is a core team for InstantRide, and they focus on…

A: SQL query to return the USER_ID, and the TRAVEL_TIME column which is calculated using the TIMEDIFF…

Q: c) Find the name of painter and painting title in gallery 18 and 24. d) Display a list of paintings…

A: SQL stands for Structured Query Language. It is a standardized programming language used for…

Q: How do you get the percentage and average of data in a column with many variables and numbers

A: To get percentage the formula should be used is: valuetotal value×100 To get average of data the…

Q: Write a SELECT statement that returns one row for each customer that has orders with these columns:…

A: The code you made:- SELECT email_address, COUNT(*) AS num_orders, SUM(quantity*(price-discount)) AS…

Q: Task 7: The StayWell marketing team considers sending small gifts to all residents and owners. To…

A: Sure, I can help you with that. The StayWell marketing team wants to send small gifts to all…

Q: 1. Write a SELECT statement that returns four columns from the Products table: ProductCode,…

A: “Since you have posted a question with multiple sub-parts, we will solve first three sub- parts for…

Q: C) Which employees earn less salary than the average salary for the consultants who perform the same…

A: According to the information given:- We have to consider the instruction to write queries on the…

Q: Which group function can be used to perform a count that includes NULL values?

A: Group by functions are : SUM ( [ALL | DISTINCT ] expression ) AVG  ( ALL | DISTINCT ] expression )…

Q: If a particular column is not allowed to be null, what is the result if the column is left empty?

A: Answer: While designing the table, the programmer should specify the particular columns null value…

Q: (6) Using ElGamal Encryption Scheme, show encryption and decryption for the following message where…

A:

Q: Write a ASQ statement to return to see all of the first names in the People table. SELECT first name…

A: We need to find the correct query for getting first names in the People table.  *As the table is not…

Q: 5. Determine the profit of each book sold to Jake Lucas, using the actual price the customer paid…

A: Profit:- Total Revenue - Total Expenses = Profit is how profit is calculated. After deducting all…

Q: List the names of all customers that have a credit limit of $7,500 or less

A: Below is the answer to above question. I hope this will be helpful for you...

Q: How do you indicate that a column alias should be used?

A: NOTE: - Below explanation is as per the oracle database. CONCEPT OF COLUMN ALIASING: - The column…

Q: Employees(employee_id, first_name, last_name, salary, hire_date, job_title, manager_id) Which of the…

A: query that will is: select e.last_name from employees e, employees m where e.manager_id =…

Q: at id, department name, location id) ueries will display the name of all employee nt ast name FROM…

A: Correct answer is (a) SELECT first_name, last_name FROM employees WHERE department id NOT IN (Select…

Q: SQL A table Products have: a name (TEXT) a description (TEXT) a unit cost stored in cents…

A: HI THERE,I AM ADDING SCHEMA AND QUERIES BELOWPLEASE GO THROUGH IT THANK YOU

Q: Below are some rows of the PROVIDERS table for a factory: PCODE 10192 98411 0489035 NAME Hans, Inc.…

A: Hello studentIn SQL querying, crafting precise SELECT statements is crucial to retrieving accurate…

Q: List the names of all Staff members who hold a faculty position and have a salary of $45,000 or…

A: SQL Space: To leave the space while displaying the data ,a function called space is used. Syntax:…

Q: If a column value is NULL, would you consider the column to be 0 or blank (" ")?

A: NULL is provided to the column when it do not have any value. so it is not consider as zero because…

Q: StayWell’s maintenance team wants to recheck the apartments that had plumbing service requests…

A: Given: StayWell’s maintenance team wants to recheck the apartments that had plumbing service…

Q: Query 3: Write a parameter query to display the names of all prospects each member tried to recruit…

A: Here have to determine query for given problem.

Q: The Finance team wants to calculate a VAT (8%) on the amount of the stay reservations in the…

A: Procedure DELIMITER// CREATE PROCEDURE VATCalculator() BEGIN SELECT…