Can we compare values of two columns in a WHERE clause?
|
|
11
|
113281
|
December 4, 2023
|
What are some other useful things that SQL lets us do?
|
|
15
|
21726
|
January 25, 2024
|
Can you CROSS JOIN on more than two tables?
|
|
35
|
37663
|
January 17, 2024
|
What types of data can SQLite databases store?
|
|
10
|
41616
|
November 7, 2023
|
Can we apply the LIKE operator to values other than TEXT?
|
|
19
|
67610
|
October 28, 2023
|
Is it possible for a table to have more than one unique identifier column?
|
|
22
|
26168
|
August 21, 2023
|
Does the ROUND() function round up?
|
|
40
|
36512
|
August 2, 2023
|
If multiple rows have the minimum or maximum value, which one is returned when using MAX/MIN?
|
|
17
|
83812
|
July 28, 2023
|
When do we use COUNT() or SUM()?
|
|
12
|
73314
|
July 28, 2023
|
Where can we access other free datasets?
|
|
2
|
8222
|
March 18, 2022
|
Can we match for a specific casing of text?
|
|
4
|
4867
|
January 11, 2024
|
What happens if we try to create a table with an existing name?
|
|
15
|
73231
|
November 12, 2023
|
What order are rows selected from a table?
|
|
8
|
54511
|
October 16, 2023
|
Does every SQL statement follow this structure?
|
|
8
|
66180
|
October 16, 2023
|
What is a function?
|
|
4
|
26955
|
September 14, 2023
|
Do column references have to follow the order the columns are listed in the SELECT?
|
|
13
|
27155
|
August 18, 2023
|
How does this statement tell us if a user is active or not active?
|
|
11
|
5253
|
March 8, 2023
|
Are we limited to only one aggregate function per query?
|
|
1
|
17707
|
May 15, 2020
|
What does a CROSS JOIN do?
|
|
2
|
5617
|
April 4, 2020
|
What if we set a LIMIT value that is greater than the total number of rows?
|
|
7
|
41161
|
July 18, 2023
|
Does making a "mini" dataset actually create a new table?
|
|
6
|
5733
|
August 3, 2023
|
What does strftime() do?
|
|
11
|
7804
|
July 8, 2022
|
Does the result change if we JOIN tables in a different order?
|
|
5
|
5452
|
February 1, 2021
|
Do the tables have to have the same number of columns when combining them?
|
|
7
|
9345
|
July 30, 2020
|
Is there a limit to the number of columns a table can have?
|
|
3
|
6568
|
March 22, 2023
|
Are 0 and "" empty values?
|
|
5
|
5287
|
July 18, 2021
|
Are there any other commonly used SQL commands?
|
|
9
|
49074
|
February 19, 2024
|
Given a value that is not a unique identifier, can we determine a unique identifier?
|
|
3
|
17258
|
November 9, 2023
|
Is it good practice to include an id column in every table?
|
|
5
|
30543
|
March 12, 2023
|
Does casing matter when selecting the names?
|
|
6
|
7036
|
January 30, 2021
|