School database
DataBaseSuppose the database of a language school contains the following tables:
Students -> ID, Name, Phone, Age
Teachers -> ID, Name, Phone, Age
1- Write a query building top tables
2- Write a query that is called a tableClassTo create that we can specify eachStudentWith which.Master, In whatDays of the weekAnd inWhat hours,WhatTextClassIt has
3. Write a query to categorize students by age and display the categories from high to low respectively. For example, 41 students 18 years old, 63 students 19 years old and ...
4. Write a query that integrates the list of students and masters and arranges and demonstrates in age.
Python
Java
JavaScript