You are creating a query that will join the results of two tables. You begin typing the query:SELECT customers.firstName, customers.lastName, orders.orderDateFROM customers ______ JOIN ordersON customers.customerNumber = orders.customerNumberYou want the query to combine each row in the customers table with each row in the orders table such that the output will be equal to the number of rows in the customers table multiplied by the number of rows in the orders table.What should you type in the blank space? (Please type your answer all in upper case. Example: SELECT or UNION ALL)

You have a sales table that has a salesAmount and a customerNumber field. You need to find the You are creating a query that will join the results of two tables. You begin typing the query:SELECT customers.firstName, customers.lastName, orders.orderDateFROM customers ______ JOIN ordersON customers.customerNumber = orders.customerNumberYou want to see all the rows from the customers table, even if they don’t have a corresponding record in the orders table.What should you type in the blank space? (Please type your answer all in upper case. Example: SELECT or UNION ALL)

Question 1Fill in the blank: To combine rows from two or more tables based on a _____ column, data professionals use the SQL JOIN clause.1 point

Table: OrdersOrderIDCustomerIDOrderDateAmount11012023-01-01500.0021022023-01-03150.0031012023-01-04200.0041032023-01-07700.0051022023-01-10300.00i. Write an SQL query to count the number of orders.ii. Write an SQL query to calculate the total amount of all orders.iii.Write an SQL query to find the total amount of orders for each customer.iv. Write an SQL query to find the largest order amount.v. Write an SQL query to find customers with a total order amount greater than 500.Answer text Question 3EditViewInsertFormatToolsTableHelp

You are tasked with managing sales data for a company. The data includes information about salesmen, customers, and orders. Write a query to find the name and numbers of all salesmen who had more than one customer.The following table is already created, and the records are inserted into the table.The Sample records are given below Input format :The input records are already prepopulated, as given in the problem statement.Output format :The output should include the Salesman_id, Salesman_Name, and Customer_Count for all salesmen who had more than one customer as shown below.Salesman_id Salesman_Name Customer_Count5 Chris Wilson 2Refer to the sample output for the column headers.

List all orders, showing order number, customer name and credit limit of a customer.Orders Table:Order_Number, Customer_Number, Product_AmountCustomers Table:Customer_Number, Customer_Name, Credit_LimitWhich of the below query satisfy the above question:A. Select Order_Number, Customer_Name, Credit_Limitfrom Customers left join Orderswhere Customer_Number = Customer_NumberB. Select Order_Number, Customer_Name, Credit_Limitfrom Customers INNER JOIN OrdersON Customers.Customer_Number = Orders.Customer_Number;