Intermediate level flashcard

Front

Which statement will show all fields and records from the table called "celebs"?

Back

SELECT * FROM celebs;

Front

What is the name of the table in this SQL query?
SELECT player_name, score FROM leaderboard;

Back

leaderboard

Front

Which SQL statement will show the names and heights of all basketball players taller than 200?

Back

SELECT name, height FROM Player WHERE height >200;

Front

Which SQL statement will show the names and weights of all wrestlers lighter than 170?

Back

SELECT name, weight FROM Wrestler WHERE weight <170;

Front

The SQL statement being run is:
SELECT player_name, score FROM leaderboard;
How many columns of results will be shown when this query is run?

Back

2

Front

Which SQL statement will show the names and heights of all basketball players taller than 200?

Back

SELECT name, height FROM Player WHERE height >200;

Front

Which SQL statement will show the names and weights of all wrestlers lighter than 170?

Back

SELECT name, weight FROM Wrestler WHERE weight <170;

Front

Which character always appears at the end of a SQL statement?

Back

;

Front

Which SQL statement will show all wrestlers sorted from the heaviest to the lightest?

Back

SELECT * FROM Wrestler ORDER BY weight DESC;

Front

Which of these statements will show all wrestlers in alphabetical order of their name

Back

SELECT * FROM Wrestler ORDER BY name ASC;