Question: Lesson 2 Specifying Your Results Software.Subscriptions subscription_id integer user_id integer order_id integer created_at timestamp unpdated_at timestamp plan_id Integer plan_type varchar(50) starts on timestamp ends_on timestamp


Lesson 2 Specifying Your Results Software.Subscriptions subscription_id integer user_id integer order_id integer created_at timestamp unpdated_at timestamp plan_id Integer plan_type varchar(50) starts on timestamp ends_on timestamp status varchar (20) cancelled at timestamp 1 select * FROM software. subscriptions LIMIT 50; schemas Pull all columns, but only 50 rows from the software subscriptions table. query.sql 10.00 out of 10.00 Nice job! Let's move on to the next exercise... Checks SQL Database Test. Complete Exercise #1 Test Using the software.subscriptions table, pull all columns for subscriptions that have been cancelled. 0.00 out of 10.00 Not quite. Edit your query and try again! Checks > SQL Database Test Incomplete Exercise #2 Test SQL Viewer + Again using the software. subscriptions table, pull all columns for premium_year subscriptions, regardless of the current status of each. 0.00 out of 10.00 Click the checkbox above to attempt this task. Checks SQL Database Test Incomplete Exercise #3 Test Run a SQL query to generate
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
