Question: solve fast D Description This project involves using various Database concepts to solve Sales use cases. This requires skills like Database concepts, SQL Queries, etc


solve fast
D Description This project involves using various Database concepts to solve Sales use cases. This requires skills like Database concepts, SQL Queries, etc In this project, the MySQL database schema consists of the following tables: - salesperson: stores sales person's data - customer: stores customer's data - orders: stores sales orders placed by customers. Exercise Find salesperson with >2 orders Write a SQL query for the following problem statement: "Find the name of salespeople with 2 or more orders." The final output should have 1 column, 'Name', the Name of the salesperson. Exercise Find salesperson with >2 orders Write a SQL query for the following problem statement: "Find the name of salespeople with 2 or more orders." The final output should have 1 column, 'Name', the Name of the salesperson. Constraints Time Limit: 1sec(s) Important Notes - Please note that sample data has already been loaded in a dedicated database for you. It is not being shared by anyone else. - In order to run the SQL Commands, please directly use table names in the queries and exclude the database name. Refer to some sample queries below for better understanding(Assume there is a table 'customer' with columns 'id' and ' name' already loaded in a database 'user'): - Write a SQL query to find the id of the customer whose name is 'ABC'. The query that you need to put in the SQL Editor below would be: SELECT id from customer where name = ' ABC ' - Write a SQL query to find the id of the customer whose name starts with 'ABC'. The query that you need to put in the SQL Editor below would be: SELECT id from customer where name LIKE 'ABC\%
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
