Query to Count the number of movies where Rating is not " G " from 4 points the table below called "library" SELECT count () WHERE rating I=G SELECT count('G) FROM library Select count(No.) FROM library WHERE rating != 'G' None of the above Query to Insert a new movie in the library table with sample data for all columns Into Library(No, Title, Type, Rating, Stars, Qty, Price) Values (11, Cocoa,Comedy,PG.Adam, 1,35.95 ) Insert Library(No, Title, Type, Rating, Star,Qty,Price) Values (11, Cocoa,Comedy.PG,Adam, 1,35,95) A and B None of the Above Give the output: SELECT COUNT (DISTINCT TYPE) FROM Library; 4 point 0 3 5 Query to Display the maximum allowance of male and of female doctors SELECT d.sex, Max(s.allowance) as MaxAllowance FROM salary s JOIN Doctor d ON d.ID=s.ID GROUP BY d. sex: SELECT s.ID, d.NAME, s.Max(allowance) as MaxAll FROM salary s OUTER JOIN Doctor d ON d.ID=s. ID GROUP BY s.ID, d. NAME HAVING sex=' F; SELECT s.ID, d. NAME, s.Max(allowance) as MaxAll FROM salary s UNION Doctor d ON d.ID=s.ID GROUP BY s.ID,d.NAME HAVING sex=F; SELECT d.sex, Maximum(s. allowance) as MaxAllowance FROM salary s JOIN Doctor d ON d.ID=s.ID GROUP BY d. sex; Query to Display the consultation fee for all doctors with 4 points experience of 10 or more. SELECT d.NAME, d.EXPERIENCE, s.CONSULTATION FROM Salary S JOIN Doctor d ON d.ID=s.ID; SELECT d.NAME, d.EXPERIENCE, S.CONSULTATION FROM DOCtOr d JOIN Salary s ON d.ID = s.ID WHERE d. Experience >=10 : SELECT d.NAME, d.EXPERIENCE, s.CONSULTATION FROM Salary S OUTER JOIN Doctor d ON d.ID =s. ID WHERE Experience >=10; None of the Above