Is the `AND` used in `BETWEEN` the same as the `AND` operator between conditions?
|
|
13
|
35457
|
July 7, 2023
|
What types of data can SQLite databases store?
|
|
11
|
44449
|
November 2, 2024
|
Can you CROSS JOIN on more than two tables?
|
|
38
|
42475
|
August 22, 2024
|
Do SQL clauses always have to be entirely capitalized?
|
|
16
|
62112
|
April 12, 2024
|
Can we compare values of two columns in a WHERE clause?
|
|
11
|
121310
|
December 4, 2023
|
Is it possible for a table to have more than one unique identifier column?
|
|
22
|
28232
|
August 21, 2023
|
Does the ROUND() function round up?
|
|
41
|
39390
|
August 1, 2024
|
Does every SQL statement follow this structure?
|
|
9
|
72947
|
May 20, 2024
|
What happens if we try to create a table with an existing name?
|
|
16
|
79726
|
May 12, 2024
|
What order are rows selected from a table?
|
|
8
|
58769
|
October 16, 2023
|
If multiple rows have the minimum or maximum value, which one is returned when using MAX/MIN?
|
|
17
|
91084
|
July 28, 2023
|
When do we use COUNT() or SUM()?
|
|
12
|
77959
|
July 28, 2023
|
Where can we access other free datasets?
|
|
2
|
8494
|
March 18, 2022
|
Can we match for a specific casing of text?
|
|
4
|
5030
|
January 11, 2024
|
What is a function?
|
|
4
|
28630
|
September 14, 2023
|
Are we limited to only one aggregate function per query?
|
|
1
|
19016
|
May 15, 2020
|
Do column references have to follow the order the columns are listed in the SELECT?
|
|
13
|
29122
|
August 18, 2023
|
How does this statement tell us if a user is active or not active?
|
|
11
|
5499
|
March 8, 2023
|
Does the result change if we JOIN tables in a different order?
|
|
6
|
5921
|
July 24, 2024
|
Does making a "mini" dataset actually create a new table?
|
|
6
|
5991
|
August 3, 2023
|
What does strftime() do?
|
|
11
|
8549
|
July 8, 2022
|
Do the tables have to have the same number of columns when combining them?
|
|
7
|
10144
|
July 30, 2020
|
What does a CROSS JOIN do?
|
|
2
|
5995
|
April 4, 2020
|
What if we set a LIMIT value that is greater than the total number of rows?
|
|
10
|
44400
|
August 13, 2024
|
Are there any other commonly used SQL commands?
|
|
10
|
52967
|
March 31, 2024
|
Is there a limit to the number of columns a table can have?
|
|
3
|
6768
|
March 22, 2023
|
Is it good practice to include an id column in every table?
|
|
5
|
33392
|
March 12, 2023
|
Are 0 and "" empty values?
|
|
5
|
5917
|
July 18, 2021
|
With SQL functions, if a parameter is optional, should you still provide a value for it?
|
|
3
|
4849
|
May 12, 2024
|
Given a value that is not a unique identifier, can we determine a unique identifier?
|
|
3
|
18361
|
November 9, 2023
|