Question: Who successfully managed to guess the smallest unique integer value? Let's find out! To keep it simply, we limited the allowed inputs to be a

Who successfully managed to guess the smallest unique integer value? Let's find out! To keep it simply, we limited the allowed inputs to be a positive number (greater than zero). Unfortunately we have not learned how to do aggregations, which can help us count the number of times a specific value was selected, in SQLjust yet. As such, we can only hand inspect our data to determine it. However, an anonymous elf has informed us that the smallest unique value is greater than 3! Write a SQL query with the columns time and smallest to try to determine what the smallest integer value is. In order to make it easier for us to inspect these values, use ORDER BY to sort the numerical values, and LIMIT your result to the first 20 values that are greater than the number 3. The first 5 lines of your output should look like this: sqlite SELECT * FROM sma11e5t_int LIMIT 5; 4/17/2019 10:19:17|4 4/19/2019 17:46:44|4 4/20/2019 20:29:22|5 4/16/2019 18:44:34|6 4/17/2019 9:44:12|6 CREATE TABLE sma11e5t_int as REPLACE THIS LINE SELECT 'YOUR CODE HERE'

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!