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;

Orders table got below attributesOrder_no, Custnbr, Product, Qty, Amt, DiscountCustomers table got below attributesCustnbr, Company, Custrep, CreditlimPrint the Order_no, Amt, Company and creditlim of the customers who placed orders. Select Order_no, Amt, Company, Creditlim from Customers outer join Orders on customers.custnbr=orders.custnbrSelect Order_no, Amt, Company, Creditlim from Customers left outer join Orders on customers.custnbr = orders.custnbrSelect Order_no, Amt, Company, Creditlim from Customers inner join Orders on customers.custnbr = orders.custnbrSelect Order_no, Amt, Company, Creditlim from Customers right outer join Orders on customers.custnbr = orders.custnbr

We have following relationorders(order_id,customer_id,order_date,amount)1) Find out the number of orders for each customer by customer_id.2) Find out the total amount by order_id and order_date.3) Find out the number of orders for each customer by customer_id. Show onlycustomer_id with number of orders above 5

The following SQL is which type of join:SELECT CUSTOMER_T.CUSTOMER_ID, ORDER_T.CUSTOMER_ID, NAME, ORDER_IDFROM CUSTOMER_T, ORDER_TWHERE CUSTOMER_T.CUSTOMER_ID = ORDER_T.CUSTOMER_IDINNER JOINCROSS JOINSELF JOINOUTER JOIN

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)

Query the customer_number from the orders table for the customer who has placed the largest number of orders.It is guaranteed that exactly one customer will have placed more orders than any other customer.The orders table is defined as follows:ColumnTypeorder_number (PK)intcustomer_numberintorder_datedaterequired_datedateshipped_datedatestatuschar(15)commentchar(200)Sample Inputorder_numbercustomer_numberorder_daterequired_dateshipped_date112017-04-092017-04-132017-04-12222017-04-152017-04-202017-04-18332017-04-162017-04-252017-04-20442017-04-182017-04-282017-04-25Sample Outputcustomer_number3ExplanationThe customer with number '3' has two orders, which is greater than either customer '1' or '2' because each of them only has one order.So the result is customer_number '3'. Follow up: What if more than one customer have the largest number of orders, can you find all the customer_number in this case?Optionsselect customer_numberfrom ( select customer_number, count(*) as cnt from orders group by customer_number) as eorder by e.cnt desclimit 1;select customer_number select customer_number, count(*) as cnt from orders group by customer_number) as eorder by e.cnt desclimit 1;select customer_numberfrom ( select customer_number, count(*) as cnt from orders group by customer_number) as elimit 1;select customer_numberfrom ( select customer_number, count(*) as cnt group by customer_number) as eorder by e.cnt desclimit 1;