|
Can we see a database's schema without being given a diagram?
|
|
0
|
9829
|
November 22, 2018
|
|
Can you CROSS JOIN on more than two tables?
|
|
38
|
41574
|
August 22, 2024
|
|
Do SQL clauses always have to be entirely capitalized?
|
|
16
|
61645
|
April 12, 2024
|
|
Can we compare values of two columns in a WHERE clause?
|
|
11
|
119579
|
December 4, 2023
|
|
What types of data can SQLite databases store?
|
|
10
|
44091
|
November 7, 2023
|
|
Is it possible for a table to have more than one unique identifier column?
|
|
22
|
27993
|
August 21, 2023
|
|
Does the ROUND() function round up?
|
|
41
|
39017
|
August 1, 2024
|
|
What happens if we try to create a table with an existing name?
|
|
16
|
78881
|
May 12, 2024
|
|
What order are rows selected from a table?
|
|
8
|
58283
|
October 16, 2023
|
|
If multiple rows have the minimum or maximum value, which one is returned when using MAX/MIN?
|
|
17
|
89820
|
July 28, 2023
|
|
When do we use COUNT() or SUM()?
|
|
12
|
77156
|
July 28, 2023
|
|
Where can we access other free datasets?
|
|
2
|
8462
|
March 18, 2022
|
|
Does every SQL statement follow this structure?
|
|
9
|
72212
|
May 20, 2024
|
|
Can we match for a specific casing of text?
|
|
4
|
5009
|
January 11, 2024
|
|
What is a function?
|
|
4
|
28445
|
September 14, 2023
|
|
Are we limited to only one aggregate function per query?
|
|
2
|
18876
|
August 30, 2024
|
|
Do column references have to follow the order the columns are listed in the SELECT?
|
|
13
|
28884
|
August 18, 2023
|
|
How does this statement tell us if a user is active or not active?
|
|
11
|
5469
|
March 8, 2023
|
|
Does the result change if we JOIN tables in a different order?
|
|
6
|
5844
|
July 24, 2024
|
|
Does making a "mini" dataset actually create a new table?
|
|
6
|
5959
|
August 3, 2023
|
|
What does strftime() do?
|
|
11
|
8328
|
July 8, 2022
|
|
Do the tables have to have the same number of columns when combining them?
|
|
7
|
9963
|
July 30, 2020
|
|
What does a CROSS JOIN do?
|
|
2
|
5950
|
April 4, 2020
|
|
What if we set a LIMIT value that is greater than the total number of rows?
|
|
10
|
43991
|
August 13, 2024
|
|
Are there any other commonly used SQL commands?
|
|
10
|
52527
|
March 31, 2024
|
|
Is there a limit to the number of columns a table can have?
|
|
3
|
6745
|
March 22, 2023
|
|
Is it good practice to include an id column in every table?
|
|
5
|
33007
|
March 12, 2023
|
|
Are 0 and "" empty values?
|
|
5
|
5722
|
July 18, 2021
|
|
With SQL functions, if a parameter is optional, should you still provide a value for it?
|
|
3
|
4684
|
May 12, 2024
|
|
Given a value that is not a unique identifier, can we determine a unique identifier?
|
|
3
|
18222
|
November 9, 2023
|