Using software.subscriptions table, pull all columns for subscriptions that have been cancelled. Athens State Uni XBb Module 4: Personal, Legal, Eth XMindTap - Cengage LearningA ng.cengage.com/static/nb/ui/evo/index.html?deploymentld%3D5990262064571697796838251&elSBN=9780357419199&id%3=1049463725&snapshotld%3D2179033&okmarksO ATHENS STATE O...☆ *BLACKBOARDATHENS STATE W...A LiveText by Water...V Citation Machine:..E EBSCOAthens State EmailCengageNGAGE MINDTAPQ Search this courses Specifying Your ResultsSpecifying</>Your Results =SQL ViewerExercise #2subscription_id user_id order_idcreated_atupdated_atplan_id plan_typestarts_onends_oncancelled atstatusThe Situation:78406818256232018-01-012019-01-012018-01-2019-01-7645276100:36:4900:36:494premium_year0101active00:36:4900:36:49Dw that you know howe Saas company has2018-01-012018-02-182018-01-2018-02-7840984926818764546534premium_year012018-02-18eir subscription dataganized, you want to00:45:1516:31:1018cancelled00:45:1516:31:1016:31:10a list of all2518-01-012019-01-012018-01-2019-01-78414852266017645643300:45:2100:45:21premium_year0101activescriptions that haven cancelled. You've00:45:2100:45:21d their product in the784169542018-01-012019-01-012018-01-2019-01-33661764573714premium_year01:38:1701:38:170101activeand were completelyfied with it. You can't01:38:1701:38:172018-01-012018-01-2019-01-ve anyone wouldwant to cancel!7842001647484764581172019-01-0101:42:4901:42:49basic_year0101active01:42:4901:42:49Task784268792018-01-012018-03-192018-01-2018-03-26303764581624premium_year2018-03-1901:45:5010:24:520119cancelled10:24:5201:45:5010:24:52Jsing thesoftware.subscr2018-01-012019-01-012018-01-2019-01-7842756340758764587474premium_yeariptions03:29:2203:29:220101active03:29:2203:29:224.

Answered: Using software.subscriptions table,…

Engineering

Computer Science

Using software.subscriptions table, pull all columns for subscriptions that have been cancelled.

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Q: The query should list all employees whose Position begins with the word greenhouse and whose weekly…

A: These question answer is as follows,

Q: LIST THE FIRST AND LAST NAMES OF ALL OWNERS WHO OWN A TWO-BEDROOM PROPERTY. USE THE IN OPERATOR IN…

A: Considering there are 2 tables:- OWNER: which holds the OWNER_NUM, FIRST_NAME, and LAST_NAME…

Q: Create a Movie table with the following columns: ID - positive integer with maximum value of 50,000…

A: The objective of the question is to create a SQL table named 'Movie' with specific columns and data…

Q: --List all products whose unit price is less than the average price. --List the shipper id,…

A: Given: consider the tables as. product { productID, productNAME, price_per_unit, category_product }…

Q: List every column in the Condo_UNIT table and its associated typ

A: The, database is a used to stores the data.

Q: List the item ID as ITEM_ID and description as ITEM_DESC for all items. The descriptions should…

A: Actually, A database is a collection of information that is organized so that it can be easily…

Q: The Book table has the following columns: ID Title Author Genre Year Price Complete the SELECT…

A: The question is asking for a SQL query that will return each genre and the total number of books in…

Q: Task 4: Create a view named PROPERTY_OWNERS. It consists of the property ID, office number, square…

A: Answer is given below .

Q: Question 1: Modify the select statement in this section to display the hire_date column in the…

A: SQL which refers to the domain specific that are used for the language and in the programming and…

Q: What formula matches the definition : "Returns a table that contains a column of dates that begins…

A: DATESBETWEEN:- Returns a table containing a column of dates that starts on the provided start date…

Q: When naming a table what prefix would you use?

A: Database by using the prefix A database prefix basically is been used to mention connectivity for a…

Q: Create a list showing only the Employee ID, Sales, and Projected Sales columns sorted from highest…

A: The query selects the specified columns from the EmployeeSales table and orders the result set based…

Q: Write the following as the MySQL query: List the employee ID, first name, last name, hire date,…

A: In database administration, it is frequently essential to extract particular data from a dataset…

Q: 8. In the OrderItems table, display the minimum item_price with the alias shown. 2.49 1 rows…

A: Below is the complete solution with explanation in detail for the given question about writing query…

Q: Q1) Please write. a query statement from emp table to display deptno 10â€™s empno, ename, sal, and a…

A: --> As new_sale is increased 15% that means it increases by 115 out of 100% which is 115/100 =…

Q: statement can remove the definition of a table. alter table update drop table delete

A: SOLUTION: drop table statement can remove the definition of a table. The DROP table command is…

Q: Orders Table: OrderID,CustomerID, Order Date, TotalAmount Customers Table: CustomerID, CustomerName.…

A: In this question we have to create a query to retrieve the customer name and order date for each…

Q: Create a Movie table with the following columns: ID - positive integer with maximum value of 50,000…

A: The objective of the question is to create a SQL table named 'Movie' with specific columns and data…

Q: CARD_NO PLAYER_NO TEAM_CODE PRICE 44 BR 4.45 27 BR 3.5 54 BR vers cards

A: query SELECT team_code,COUNT(card_no) AS TOTAL_CARD_NO, to_char(SUM(price),'$99.99') as total_price…

Q: List the trip name, trip id and customer number of all reservations for hiking trips. Sort the…

A: Explanation: The query displays the trip id, trip name, and start location using the “TRIP” object…

Q: Refer to the CREATE TABLE statement: CREATE TABLE Country ( ); Name VARCHAR (50), Population INT,…

A: The question is asking to complete an SQL INSERT INTO statement to add a new row into the 'Country'…

Q: 10-Create a products table that has product id, product name, and price fields. Write a query to…

A: Algorithm : 1) Create the table products. 2) Insert some values in the table. (I have added 4…

Q: how is duplicate column prefixed when duplicate column appear in Join Query? a) Table name followed…

A: The question is asking about the way to prefix a duplicate column when it appears in a Join Query in…

Concept explainers

Multiple Table

In a database, a table is used to store data in the form of rows and columns. Rows are aligned horizontally and identified by one or more values in a specific column. Columns are vertically aligned and identified by a unique column name.

Question

Using software.subscriptions table, pull all columns for subscriptions that have been cancelled.

Athens State Uni X
Bb Module 4: Personal, Legal, Eth X
MindTap - Cengage Learning
A ng.cengage.com/static/nb/ui/evo/index.html?deploymentld%3D5990262064571697796838251&elSBN=9780357419199&id%3=1049463725&snapshotld%3D2179033&
okmarks
O ATHENS STATE O...
☆ *
BLACKBOARD
ATHENS STATE W...
A LiveText by Water...
V Citation Machine:..
E EBSCO
Athens State Email
Cengage
NGAGE MINDTAP
Q Search this course
s Specifying Your Results
Specifying
</>
Your Results =
SQL Viewer
Exercise #2
subscription_id user_id order_id
created_at
updated_at
plan_id plan_type
starts_on
ends_on
cancelled at
status
The Situation:
78406818
25623
2018-01-01
2019-01-01
2018-01-
2019-01-
76452761
00:36:49
00:36:49
4
premium_year
01
01
active
00:36:49
00:36:49
Dw that you know how
e Saas company has
2018-01-01
2018-02-18
2018-01-
2018-02-
78409849
26818
76454653
4
premium_year
01
2018-02-18
eir subscription data
ganized, you want to
00:45:15
16:31:10
18
cancelled
00:45:15
16:31:10
16:31:10
a list of all
2518-01-01
2019-01-01
2018-01-
2019-01-
78414852
26601
76456433
00:45:21
00:45:21
premium_year
01
01
active
scriptions that have
n cancelled. You've
00:45:21
00:45:21
d their product in the
78416954
2018-01-01
2019-01-01
2018-01-
2019-01-
33661
76457371
4
premium_year
01:38:17
01:38:17
01
01
active
and were completely
fied with it. You can't
01:38:17
01:38:17
2018-01-01
2018-01-
2019-01-
ve anyone would
want to cancel!
78420016
47484
76458117
2019-01-01
01:42:49
01:42:49
basic_year
01
01
active
01:42:49
01:42:49
Task
78426879
2018-01-01
2018-03-19
2018-01-
2018-03-
26303
76458162
4
premium_year
2018-03-19
01:45:50
10:24:52
01
19
cancelled
10:24:52
01:45:50
10:24:52
Jsing the
software.subscr
2018-01-01
2019-01-01
2018-01-
2019-01-
78427563
40758
76458747
4
premium_year
iptions
03:29:22
03:29:22
01
01
active
03:29:22
03:29:22
4.

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

This is a popular solution!

SEE SOLUTION Check out a sample Q&A here

Step 1: INTRODUCTION

VIEW

Step 2: EXPLANATION

VIEW

Solution

VIEW

Trending now

This is a popular solution!

Step by step

Solved in 3 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions

10. Produce a list of each customer number and the third and fourth digits of his or her zipcode. The query should also display the position of the first occurrence of a 3 in thecustomer number, if it exists. SQL commands
What prevents a column from having a NULL value?
Update rows in Horse table Using MYSQL The Horse table has the following columns: ID - integer, auto increment, primary key RegisteredName - variable-length string Breed - variable-length string, must be one of the following: Egyptian Arab, Holsteiner, Quarter Horse, Paint, Saddlebred Height - decimal number, must be ≥ 10.0 and ≤ 20.0 BirthDate - date, must be ≥ Jan 1, 2015 Make the following updates: Change the height to 15.6 for horse with ID 2. Change the registered name to Lady Luck and birth date to May 1, 2015 for horse with ID 4. Change every horse breed to NULL for horses born on or after December 22, 2016.
WEEK 3 ASSIGNMENT Complete the following exercise: Using the student table you created in week two insert four rows into your table. Update the first name to “Luke” and last name to “Plew” for one of the rows you inserted above. Delete the row you updated above. Explain how you insert data in one table from another table. Your answer should be a minimum of three sentences in length.
WEEK 2 ASSIGNMENT Complete the following exercise: Using the student table you created in week one insert four rows into your table. Update the first name to “Luke” and last name to “Plew” for one of the rows you inserted above. Delete the row you updated above. Explain how you insert data in one table from another table. Your answer should be a minimum of three sentences in length.
The Colombia City office of StayWell indicated that there is a new tenant by the name of Yigit Yilmaz staying at the property with an ID of 13. You need to include this new resident in the RESIDENTS table.
List the names of all customers that have a credit limit of $7,500 or less
Create a table named company with these columns: Company_id varchar(255) Company_name varchar(255) default ‘x’ Hq_phone_number varchar(255) Primary key of company_id (please use constraint format) Unique key of Hq_phone_number (please use constraint format)
List the names of all Staff members who hold a faculty position and have a salary of $45,000 or less. Show their names as their first name, followed by a space, and then their last name but sort the list alphabetically by last name and then first name. Hint: Check out the Position column in the Staff table. All staff members who do not hold a faculty position will get a bonus this year equal to 5% of their salary. List the names, current salary, and bonus amount for each Staff member (non-faculty) who is due a bonus. Show your list in order with the person receiving the highest bonus first.
Add a column named ON_HAND_VALUE to the NONCAT table. The on-hand value is a seven-digit number with two decimal places that represents the product of the number of units on hand and the price. Then set all values of ON_HAND_VALUE to ON_HAND * PRICE.
Column name Datatype Description trainer_id Should increment what is the datatype and size?
The Horse table has the following columns: ID - integer, auto increment, primary key RegisteredName - variable-length string Breed - variable-length string, must be one of the following: Egyptian Arab, Holsteiner, Quarter Horse, Paint, Saddlebred Height - decimal number, must be between 10.0 and 20.0 BirthDate - date, must be on or after Jan 1, 2015 Insert the following data into the Horse table: RegisteredName Breed Height BirthDate Babe Quarter Horse 15.3 2015-02-10 Independence Holsteiner 16.0 2017-03-13 Ellie Saddlebred 15.0 2016-12-22 NULL Egyptian Arab 14.9 2019-10-12