Which database feature can be used to list the names of the male students from a particular class?*1 pointFormTableReportQuery

Possibility High School maintains a database containing tables related to its students and the subjects offered. Which of the following represents a table within the database?*1 pointa student's namea student's recordall the personal data on studentsthe age of a student

This task concerns the following tables:PersonsidnameaddressageeyeColorgenderTakesClassesidperson_id → Personsclass_id → ClassesWrite a query that returns a table with columns name and nrOfClasses that contains the list of all names of people and the number of classes that this person takes.NoteYou can give names to columns in the SELECT clause by SELECT …​ as someName.

2.Question 2You are the database administrator for a school. Student information is kept in a students table where students are tracked by student_id. Students have a grade point average listed for each semester in a table named grades where each student is referenced by student_id.The school is giving an award to all students who achieved a 4.0 grade point average during any semester. You need to generate a list of all the students who should get the award. You begin typing your query:What should you type in the blank space? (Please type your answer all in lower case. Example: select)1 point

Create a stored procedure. findStudents and write a query inside it to find a particular user(s) by their Department and display only the name and phone fields.The user name will be passed as an input to the procedure with data type VARCHAR(20).A Table named users is already been created.Sample TableNote :Table names are case-sensitive.Write only the logic for the procedure. The calling of the stored procedure and the creation of the tables are already written in the background.Input format :No console input.Output format :The output will display the names and phone numbers of the students of ECE and CIVIL departments.

Give the database schema the following tables: Student (studentId, firstName, lastName, gender, birthday, phone, address, classId) Class (classId, className) Which code snippet will display records with the following 3 columns: classId, className and amount (amount of students)?SELECT c.classId, c.className, COUNT(*) AS amountFROM dbo.Class c INNER JOIN dbo.Student s ON c.classId = s.classId;SELECT c.classId, c.className, COUNT(*) AS amountFROM dbo.Class c INNER JOIN dbo.Student s WHERE c.classId = s.classIdGROUP BY c.classId, c.className;SELECT c.classId, c.className, COUNT(*) AS amountFROM dbo.Class c INNER JOIN dbo.Student s ON c.classId = s.classIdGROUP BY c.classId;SELECT c.classId, c.className, COUNT(*) AS amountFROM dbo.Class c INNER JOIN dbo.Student s ON c.classId = s.classIdGROUP BY c.classId, c.className;