I need help with questions 18,19,and 20 14. How many records are created when you apply a Cartesian join (Cross join) to the invoice andinvoice items table?1. The following diagram is a depiction of what type of join?a.Inner Joinb. Full outer joinC. Left joind. Right join16. Select which of the following statements are true regarding inner joins. (Select all that apply)a. There is no limit to the number of table you can join with an inner join.b.Performance will most likely worsen with the more joins you makeInner joins retrieve all matching and nonmatching rows from a tabled. Inner joins are one of the most popular types of joins use17. Which of the following is true regarding Aliases? (Select all that apply.)a. Aliases are often used to make column names more readableb.SQL aliases are used to give a table, or a column in a table, a temporary name.An alias only exists for the duration of the query.18. What is wrong with the following query?SELECT Customers.CustomerName, Orders.OrderIDFROM LEFT JOIN ON Customers.CustomerID = Orders.CustomerID FROM Orders AND CustomersORDER BYCustomerName;19. Write a query to find the total number of invoices for each customer along with the customer's fullname, city and email.20. Write a query to retrieve the track name, album, artistID, and trackID for all the albums.C.table1C.table2

To create a program that executes the corrected SQL query and fetches the desired results, you can follow these general steps:Choose a programming language: Select a programming language that supports database connectivity and has appropriate libraries or modules for executing SQL queries. Common choices include Python, Java, C#, and PHP.Set up the database connection: Install the necessary libraries or modules to connect to your database. These could include drivers or connectors specific to your database system (e.g., MySQL, PostgreSQL, SQLite).Establish the database connection: Use the provided credentials (username, password, host, port) to establish a connection to the database.Write the SQL query: Implement the corrected SQL query within your program. Make sure to use the appropriate syntax for the selected programming language to execute the query.Execute the query: Use the established database connection to execute the SQL query and retrieve the results. This typically involves invoking a method or function provided by the database library or module.Process the results: Retrieve the fetched results from the executed query and process them as needed. This might involve iterating over the result set, extracting specific columns or values, performing calculations, or formatting the output.Display or use the results: Present the processed results to the user or use them for further computations within your program, depending on the specific requirements.Handle errors: Implement appropriate error handling to catch and handle any potential errors that might occur during the execution of the program, such as database connection issues or syntax errors in the query.Clean up: Close the database connection and release any allocated resources once you have finished executing the query and processing the results.Test and refine: Run the program, validate the output, and make any necessary refinements or enhancements based on your testing results.Answer :1SELECT Customers.CustomerName, Orders.OrderID 2FROM Customers 3LEFT JOIN Orders ON Customers.CustomerID = Orders.CustomerID 4ORDER BY Customers.CustomerName ASCExplanation :There are a few issues with the provided query:Syntax error: The syntax of the query is incorrect. The correct syntax for a SELECT statement is: SELECT column1, column2, ... FROM table1 JOIN table2 ON condition WHERE condition ORDER BY columnIncorrect table aliases: The table aliases "Customers" and "Orders" are separated by a space, which is not valid syntax. You should remove the space between the table aliases.Incorrect join syntax: The "LEFT JOIN" statement is missing the "ON" keyword and the condition for joining the tables. Additionally, the "FROM" keyword is used multiple times in the query.Typo in column selection: There is an extra space between "Customers." and "CustomerName" in the SELECT clause. Remove the space to correct it.Incorrect ORDER BY syntax: The colon (":") is used instead of the "ASC" or "DESC" keywords to specify the sorting order.The provided query has multiple issues with its syntax and structure. The corrected query selects the "CustomerName" column from the "Customers" table and the "OrderID" column from the "Orders" table, joins them on the "CustomerID" column using a left join, and orders the results by the "CustomerName" column in ascending order.

Answered: 18. What is wrong with the following…

Engineering

Computer Science

18. What is wrong with the following query? SELECT Customers. CustomerName, Orders. OrderID FROM LEFT JOIN ON Customers.CustomerID = Orders.CustomerID FROM Orders AND Customers ORDER BY CustomerName;

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

Task 1: ' The Car Maintenance team wanted to ensure that the default price of the maintenance actions should not be empty and 0 instead if not specified. Alter the MAINTENANCE_TYPES table created in Chapter 8, Activity 1 to set the default MAINTENANCE_PRICE to 0. ANSWER IN MYSQL PLEASE
You have been tasked by the Human Resource department to assist in calculating bonuses for all employees. A bonus is a sum of money added to an employee's salary as a reward for good performance. The columns in the Employees table are named EmployeelD, EmployeeFirstName, EmployeeLastName, and Salary. The EmployeelD column is the primary key of the table. Write a SQL statement to create a procedure BONUS_DATA. USING the EMPLYEES table, you have the requirement to display EmployeelD, EmployeeFirstName, EmployeeLastName, Salary and the New salary for all the employees. Based on the bonus your procedure should calculate the new salary for each of the employees. The bonus will be calculated using the following criteria: Salary Range Bonus: 0- 1000 Bonus 25% of salary 1001 – 2000 Bonus 20% of salary 2001 – 3000 Bonus 15% of salary 3001 – 4000 Bonus 10% of salary 4001 – 50000 Bonus 5% of salary >50000 Bonus 0% of salary
StayWell’s maintenance team wants to recheck the apartments that had plumbing service requests beforehand. You will need to return all the property IDs and the addresses of the properties that had plumbing service request (CATEGORY_NUMBER 1). Task Return a list of all the property IDs and the addresses of the properties that had plumbing service requests.
Task 2: ' The Driver Relationship team wants to ensure that the all driving license IDs in the active drivers table have the length of 7. Alter the ACTIVE_DRIVERS table created in Chapter 8, Activity 1 to check the length of the DRIVER_DRIVING_LICENSE_ID.
question 6 use the picture below to answer the following question Add a ZIP field/column to the customer table.
Which clause is used to change a column in a table? a. SET b. MODIFY c. ALTER d. UPDATE
last 3 subparts
Task 22: KimTay Pet Supplies is considering discounting the price of all items by 10 percent. List the item ID, description, price, and discounted price for all items. Use DISCOUNTED_PRICE as the name for the computed column.
Task 9: Create the DELETE_INVOICE procedure to delete the invoice whose number is stored in I_INVOICE_NUM.
q19- Please choose for each line from step 1,2,3,4,5
Computer Science A study conducted by Netflix’s consumer relations department has revealed that customers are more likely to review horror and thriller movies during certain months of the year. To discourage seasonal variations in these movie ratings, Netflix has called for your help to analyze horror and thriller movie rating counts over the past 15 years. Your query should display each month of the year (name of the month not the number) and the total number of ratings given during that month. A third column titled “Promotion Recommendation” determines whether a promotion should be applied to increase the number of ratings given during that month. If a month has less than 2200 ratings the final column should display ‘10% discount promotion’, if between 2201 and 4500 then display ‘5% discount promotion’, and if more than 4500 ratings then output ‘No Promotion’. Order your results by months. Do not hardcode the current date. ORALCE CODE PLEASE.
Could you do typing the query here please?