Sajid Mahmud Sayan
Grade 7 | Points: 39545 | Rank: 111
Hello! I'm ѕαʝιɗ мαнмυɗ sαуαи, a 12-year-old coder from Bangladesh in grade 7. I love coding and learning new platforms like Python,Javascript,Html, Lua. My top projects are "Gaming Hub" "Number Guess" and "Subway Surfers"
Hobby: Coding,Computer Programming,ETC
Classes completed
175
Quizzes submitted
171
Projects submitted
164
Hackathons
Code Clash Championship | Hackathon Competition for Kids and Teens
Hosted by: IIT Kanpur Antargani
Indian Institute of Science Junior Code Clash 2023
Hosted by: Indian Institute of Science, Bangalore
Activities
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.