In SQL, which of the following syntax is correct for filtering the sum of spends? A. SELECT SUM(spend), gender FROM tblstudent WHERE gender = ‘male’ B. SELECT SUM(spend), gender FROM tblstudent GROUP BY gender = ‘male’ C. SELECT SUM(spend), gender…
In SQL, which of the following syntax is correct for the sum of spends? A. SELECT SUM(spend), gender FROM tblstudent B. SELECT SUM(spend), gender FROM tblstudent GROUP gender C. SELECT SUM(spend), gender FROM tblstudent GROUP BY gender D. None correct…
In SQL, which of the following syntax is correct for the average of age? A. SELECT AVG(age), gender FROM tblstudent B. SELECT AVG(age), gender FROM tblstudent GROUP gender C. SELECT AVG(age), gender FROM tblstudent GROUP BY gender D. None correct…
In SQL, which of the following syntax is correct for the count cid? A. SELECT COUNT(cid), gender FROM tblstudent WHERE gender = ‘male’ B. SELECT COUNT(cid), gender FROM tblstudent GROUP BY gender = ‘male’ C. SELECT COUNT(cid), gender FROM tblstudent…
In SQL, which of the following syntax is correct about group by cid? A. SELECT COUNT(cid), gender FROM tblstudent B. SELECT COUNT(cid), gender FROM tblstudent IN GROUP gender C. SELECT COUNT(cid), gender FROM tblstudent GROUP BY gender D. None correct…
In SQL, which of the following syntax is correct about order by name? A. SELECT * FROM tblstudent ORDER BY name WHERE name = ‘sok’ B. SELECT * FROM tblstudent WHERE name = ‘sok’ ORDER name C. SELECT * FROM…
In SQL, how to select multiple attributes from tblstudent? A. SELECT cid & name FROM tblstudent B. SELECT cid AND name FROM tblstudent C. SELECT cid, name FROM tblstudent D. None correct Answer: Option C
What syntax is correct to filter the student’s name is not ‘sok’? A. SELECT * FROM tblstudent WHERE name != ‘sok’ B. SELECT * FROM tblstudent WHERE name >< 'sok' C. SELECT * FROM tblstudent WHERE name ‘sok’ D. None…
In SQL, What syntax is correct for filtering student name’s sok or male? A. SELECT * FROM tblstudent WHERE name = ‘sok’ | gender = ‘male’ B. SELECT * FROM tblstudent WHERE name = ‘sok’ || gender = ‘male’ C.…
What syntax is correct for filtering student name’s sok and male? A. SELECT * FROM tblstudent WHERE name = ‘sok’ & gender = ‘male’ B. SELECT * FROM tblstudent WHERE name = ‘sok’ && gender = ‘male’ C. SELECT *…
KB Cambodia