Difference between revisions of "BBC QUIZ"

Revision as of 12:58, 16 July 2012

BBC QUIZ

@@ Line 11: / Line 11: @@
 {Which of these shows just the population of United Kingdom?
 |type="()"}
-- SELECT population FROM bbc WHERE name = 'United Kingdom'
+- SELECT name FROM bbc WHERE name Like 'United%'
-- SELECT population FROM bbc WHERE name = United Kingdom
 - SELECT name FROM bbc WHERE population = 'United Kingdom'
 - SELECT name, population FROM bbc WHERE name = 'United Kingdom'
-+ SELECT name FROM bbc WHERE name Like 'United%'
++ SELECT population FROM bbc WHERE name = 'United Kingdom'
+- SELECT population FROM bbc WHERE name = United Kingdom
 {What is the problem with this SQL code:SELECT name FROM "bbc" WHERE population > '2000000'?

	SELECT name FROM bbc WHERE name BEGIN with C
	SELECT name FROM bbc WHERE name LIKE '%C'
	SELECT name FROM bbc WHERE name LIKE '%C%'
	SELECT name FROM bbc WHERE name LIKE C
	SELECT name FROM bbc WHERE name LIKE 'C%'

	SELECT name FROM bbc WHERE name Like 'United%'
	SELECT name FROM bbc WHERE population = 'United Kingdom'
	SELECT name, population FROM bbc WHERE name = 'United Kingdom'
	SELECT population FROM bbc WHERE name = 'United Kingdom'
	SELECT population FROM bbc WHERE name = United Kingdom

	Apostrophes should be used around 'bbc' instead of speech marks
	There are apostrophes surrounding '2000000'
	There are speech marks surrounding "bbc"
	There are speech marks surrounding "bbc" and there is apostrophes surrounding '2000000'
	None of the above

	SELECT name FROM bbc WHERE region IN ('Europe', 'North America', 'South America')
	SELECT name, population FROM bbc WHERE region IN ('Europe', 'North America', 'South America')
	SELECT name, population FROM bbc WHERE region IN (Europe North America South America)
	SELECT name, population FROM bbc WHERE region IS ('Europe', 'North America', 'South America')
	SELECT population FROM bbc WHERE region IN ('Europe', 'North America', 'South America')

	SELECT name FROM bbc WHERE name = 'United Kingdom' AND name = 'Algeria'
	SELECT name FROM bbc WHERE name = 'United Kingdom' or name = 'Algeria'
	SELECT name FROM bbc WHERE name EITHER ('United Kingdom', 'Algeria')
	SELECT name FROM bbc WHERE name IN ('United Kingdom', 'Algeria')
	None of the above