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