22 March 2024
26 March 2024
Write a SQL query to generate a report with the following columns:
a. CustomerCount - To get the total number of customers, use the 'CustomerID' column.
b. OrderCount - To get the total count from orders, use the 'OrderID' column.
c. City - use the Customers table's 'city' column.
Consider that both the customers and the orders are in the same city. i need answer for this
Arunagirinathan DharmanWrite a SQL query to generate a report with the following columns:
a. CustomerCount - To get the total number of customers, use the 'CustomerID' column.
b. OrderCount - To get the total count from orders, use the 'OrderID' column.
c. City - use the Customers table's 'city' column.
Consider that both
Use count(*)
27 March 2024
28 March 2024
31 March 2024