You have a database that tracks students by student_id. The entire school is scheduled to go on a field trip to the nation’s capital. In order to attend the field trip, each student must submit a permission slip signed by a parent. You have been storing the scanned permission slips in a table named slips. The field trip is in two weeks. The head of the school wants to send an email to all the students who have not submitted permission slips. You begin typing your query:What should you type in the blank space? (Please type your answer all in upper case. Example: SELECT or UNION ALL)

You 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)

Write a query to display the number of students having invalid email id.The valid email ids should have “@” anywhere after the first character and should end with “.com”. Give an alias name for the count as ‘student_count’.

You have a database with a table that tracks students in a private school. You execute the following statement:You get the following result:You are preparing to enter in a number of records for the upcoming year. You begin typing your statement:What should you type in the blank space? 1 point

ou have a database that tracks students in the students table by student_id. Students may get warnings for low grades or poor behavior. The warnings are tracked in the warnings table where the student is referred to by student_id.You need to create a query that finds the first and last name of the student who has the most records in the warnings table. You begin typing your query:What should you type in the blank space? (Please type your answer all in lower case. Example: select)

Consider these following tables and only solve the query. Tables: 1) student: s_no (primary key), student_name, course_no (foreign key), age 2) courser-course-no (primary key), course-name.