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