Coding Activities by Sajid Mahmud Sayan
New York Restaurant
Use the SQL commands you just learned and find the best dinner spots in the city and answer the following questions: 1)What are the distinct neighborhood 2)What are the distinct cuisine types? 3)Suppose we would like some Chinese takeout. What are our options? 4)Return all the restaurants with reviews of 4 and above. 5)Suppose Abbi and Ilana want to have dinner. Return all the restaurants that are Italian and $$$. 6)If you want to find Italian restaurants with exactly three dollar signs: 7)Your coworker Trey can’t remember the exact name of a restaurant he went to but he knows it contains the word ‘Candy’ in it. Can you find it for him using a query? 8)Let’s order delivery to the house! Find all the close-by spots in Midtown, Downtown or Chinatown 9)Find all the health grade pending restaurants (empty values). 10)Create a Top 4 Restaurants Ranking based on reviews
New York Restaurant
Use the SQL commands you just learned and find the best dinner spots in the city and answer the following questions: 1)What are the distinct neighborhood 2)What are the distinct cuisine types? 3)Suppose we would like some Chinese takeout. What are our options? 4)Return all the restaurants with reviews of 4 and above. 5)Suppose Abbi and Ilana want to have dinner. Return all the restaurants that are Italian and $$$. 6)If you want to find Italian restaurants with exactly three dollar signs: 7)Your coworker Trey can’t remember the exact name of a restaurant he went to but he knows it contains the word ‘Candy’ in it. Can you find it for him using a query? 8)Let’s order delivery to the house! Find all the close-by spots in Midtown, Downtown or Chinatown 9)Find all the health grade pending restaurants (empty values). 10)Create a Top 4 Restaurants Ranking based on reviews
Department Table and Aggregate Queries
In this activity, students have to create a” DEPARTMENT” TABLE and have to perform these actions : 1)Write a query that displays the number of employees working in each department. 2)Write a query that displays the total salary paid to employees working in each department. 3)Write a query that displays the number of employees, total salary paid to employees working in each department. 4)Write a query that displays the department code, total salary paid to employees group by department_id and manager_id=103. 5)Write a query that displays the department id, number of employees of those groups that have more than 2 employees
Student Table Queries
-Create a 'STUDENT" Table and use "AND"& "OR"Operators to filter the necessary data asked in the question like: 1)To fetch all the records from the Student table where Age is 18 and ADDRESS is Delhi 2)To fetch all the records from the Student table where NAME is Ram and Age is 18. 3)To fetch all the records from the Student table where NAME is Ram or NAME is SUJIT. 4)To fetch all the records from the Student table where NAME is Ram or Age is 20. 5)To fetch all the records from the Student table where Age is 18 NAME is Ram or RAMESH.