As a part of marketing strategy, the Marketing team continuously conducting an advertising campaign on different channels. The team would like to know how this campaign is impacting the overall rides being taken through the InstantRide, specifically the rides which cost $5 or more.You need to send the number of travels calculated for each day and month with their totals using Month, Day and Count column names. Furthermore, you can name your subquery as PREMIUM_RIDES to work only with the travels with the price of 5 or higher. In the USERS table, information for the users are stored with their first name, last name andemail:USER IDUSER_FIRST_NAMEUSER_LAST_NAMEUSER EMAIL3001JackHillj.hill@xmail.com3002RyanCollinsr.collins@xmail.com3003NursinYilmazn.atak@gmail.com3004SarahPrices.price@xmail.com3005BobbyGriffinb.griffin@xmail.com3006RandyClarkr.clark@xmail.com3007JoseThomasj.thomas@xmail.com3008NursinYilmazn.yilmaz@xmail.comUSERS TableIn the DRIVERS table, all the drivers in the InstantRide are stored with their name, drivinglicense number and check and rating information:DRIVER ID DRIVER_FIRST_NAME DRIVER LAST_NAME DRIVER_DRIVING_LICENSE_IDDRIVER START_DATE DRIVER_DRIVING_LICENSE_CHECKEDDRIVER_RATING2001WillieButler18745012019-09-1214.42002JustinHoward19538532019-09-0914.82003AnthonyWalker17354872019-09-153.52004ЕсеYilmaz17347472019-08-15DRIVERS TableIn the CARS table, all the cars in the InstantRide system are kept with the license plate, modeland year:CAR IDCAR_PLATECAR_MODELCAR_YEAR1001ВB-542-АВTOYOTA PRIUS20181002BB-883-EETESLA MODEL 320191003BB-451-ZNTOYOTA AURIS20191004BB-189-MMMERCEDES E2002019CARS Table TRAVEL_IDTRAVEL START TIMETRAVEL END TIMETRAVEL START LOCATIONTRAVEL_END LOCATIONTRAVEL PRICEDRIVER IDCAR IDUSER IDTRAVEL DISCOUNTs0012019-10-01 04:04:552019-10-01 04:14:199614 York Road84 Church Lane15.44200110033005NULL50022019-10-01 05:57:332019-10-01 06:12:3347 Church Street68 High Street20.56200110033006NULL50032019-10-01 13:35:202019-10-01 13:45:102 Windsor Road95 West Street12.32200210013002NULL50042019-10-02 08:44:482019-10-02 09:15:289060 Mill Lane27 Main Road30.492003100230010.1350052019-10-02 16:38:542019-10-02 16:48:102 Queensway24 Mill Lane11.15200110033007NULL50062019-10-03 19:12:142019-10-03 19:23:4550 Main Road93 Broadway14.612003100230070.1050072019-10-03 16:06:362019-10-03 16:08:5639 Park Road91 West Street4.412002100430030.1417 Stanley Road50082019-10-03 17:17:122019-10-03 17:37:4237 The Drive25.122001100330010.2550092019-10-03 21:16:482019-10-03 21:26:1877 Mill Road724 Springfield Road13.55200110033005NULL50102019-10-03 23:21:402019-10-03 23:39:1016 Church Road30 North Road25.622003100230030.20TRAVELS Table

Actually, database is used to stores the data and manipulate, change and modify the data.

As a part of marketing strategy, the Marketing team continuously conducting an advertising campaign on different channels. The team would like to know how this campaign is impacting the overall rides being taken through the InstantRide, specifically the rides which cost $5 or more. You need to send the number of travels calculated for each day and month with their totals using Month, Day and Count column names. Furthermore, you can name your subquery as PREMIUM_RIDES to work only with the travels with the price of 5 or highe

As a part of marketing strategy, the Marketing team continuously conducting an advertising campaign on different channels. The team would like to know how this campaign is impacting the overall rides being taken through the InstantRide, specifically the rides which cost $5 or more. You need to send the number of travels calculated for each day and month with their totals using Month, Day and Count column names. Furthermore, you can name your subquery as PREMIUM_RIDES to work only with the travels with the price of 5 or highe

Oracle 12c: SQL

3rd Edition

ISBN:9781305251038

Author:Joan Casteel

Publisher:Joan Casteel

Chapter3: Table Creation And Management

Section: Chapter Questions

Problem 4MC: Which of the following is not a valid SQL statement? CREATE TABLE anothernewtable (newtableid...

See similar textbooks

Similar questions

A new table has been requested to support tracking automated emails sent to customers. Create the table and add data as described below. Tablename: email_log Columns: emailid (numeric), emaildate (datetime), customer# (numeric) Primary key: emailid column, define as an Identity Column Add the following data rows and display resulting rows (if any errors occur, explain why the error is expected) Emaildate = current date, customer# = 1007 Emailid = specify to use the column default value, emaildate = current date, customer# = 1008 Emailid = 25, emaildate = current date, customer# = 1009
How many NOT NULL constraints can be created at the table level by using the CREATE TABLE command? 0 1 12 30 255
Which of the following statements deletes all rows in the HOMEWORK10 table? a. DELETE FROM homework10; b. DELETE . FROM homework10; c. DELETE FROM homework10; d. DELETE FROM homework10 WHERE amid = ; e. Both c and d delete all rows in the HOMEWORK10 table.
Which of the following is a valid SQL statement? SELECT * WHERE amid = ‘J100’ FOR UPDATE; INSERT INTO homeworkl0 VALUES (SELECT * FROM acctmanager); DELETE amid FROM acctmanager; rollback; all of the above
Which of the following commands creates a new table containing a virtual column? a. CREATE TABLE newt able AS (SELECT order#, title, quantity, retail FROM orders); b. CREATE TABLE newt able (price NUMBER (3), total NUMBER (8, 2)); c. CREATE TABLE newt able (calc1 NUMBER (4), calc2 NUMBER (4); d. CREATE TABLE newt able (cola NUMBER (3), colb NUMBER (3), cole AS (cola+colb));
Which of the following is not a valid SQL statement? CREATE TABLE anothernewtable (newtableid VARCHAR2 (2)); CREATE TABLE anothernewtable (date, anotherdate) AS (SELECT orderdate, shipdate FROM orders); CREATE TABLE anothernewtable (firstdate, seconddate) AS (SELECT orderdate, shipdate FROM orders); All of the above are valid statements.
I need the output of the queries create table Accounts (account_no number primary key, client_name varchar2(200),Gender varchar2(20),address Varchar2(200)); create table loans (branch_id number, bank_name varchar2(200),Loan number, loan_Status varchar2(200),account_no number references Accounts(account_no) ON DELETE CASCADE); 1. delete from accounts where account_no= 101; 2. select * from accounts a where exists (select 1 from loans l where l.account_no= a.account_no) 3. select * from accounts a where exists (select 1 from loans l where l.account_no= a.account_no and status = 'accepted') 4. create or replace view view1 as select client_name , address,l.bank_name,l.loan_Status from accounts a, loans l where a.account_no = l.account_no Step 2 5.create or replace view view2 as select client_name , address,l.bank_name,l.loan_Status from accounts a, loans l where a.account_no = l.account_no and address = 'Karachi' 6. create or replace view view3 as select client_name ,…
what is these codes insert into values()... CREATE TABLE [Car] ([CarID] varchar(30),[SerialNumber] varchar(50),[Model] varchar(30),[Colour] varchar(30),[Year] varchar(20),PRIMARY KEY ([CarID])); CREATE TABLE [ServiceTicket] ([ServiceticketID] varchar(40),[Serviceticketnumber] varchar(40),[CarID] varchar(30),[CustomerID] int,[Datarecieved] varchar(30),[Comments] varchar(100),[Datareturnedcustomer] varchar(100),PRIMARY KEY ([ServiceticketID]),CONSTRAINT [FK_ServiceTicket.CustomerID]FOREIGN KEY ([CustomerID])REFERENCES [Customer]([CustomerID]),CONSTRAINT [FK_ServiceTicket.CarID]FOREIGN KEY ([CarID])REFERENCES [Car]([CarID])); CREATE TABLE [ServiceMechanic] ([ServicemechanicID] varchar(40),[ServiceticketID] varchar(40),[ServiceID] int,[MechanicID] int,[Hours] varchar(10),[Comment] varchar(100),[Rate] varchar(40),PRIMARY KEY ([ServicemechanicID]),CONSTRAINT [FK_ServiceMechanic.MechanicID]FOREIGN KEY ([MechanicID])REFERENCES [Mechanic]([MechanicID]),CONSTRAINT…
Assuming the HOMEWORK10 table has three columns (Col1, Col2, and Col3, in this order), which of the following commands stores a NULL value in Col3 of the HOMEWORK10 table?a. INSERT INTO homework10 VALUES (‘A’, ‘B’, ‘C’);b. INSERT INTO homework10 (col3, col1, col2) VALUES (NULL, ‘A’, ‘B’);c. INSERT INTO homework10 VALUES (NULL, ‘A’, ‘B’);d. UPDATE homework10 SET col1 = col3;
Some rows of a User table are shown below: User ucode name phone scode 7 Alex 847 - 3902 UX 8 Tony 203 - 3902 PX 9 Charles BD 11 Mary 877 - 3333 BD Which of the following queries retrieves the rows where there is no phone? a. SELECT * FROM User WHERE phone IS NULL b. SELECT * FROM User WHERE phone = “ ” c. SELECT * FROM User WHERE phone NOT IS NULL d. SELECT * FROM User WHERE phone > 0
The PatientDim table contains columns. PatientEpicId and name. Use the following query to answer the questions below it: SELECT PatientEpicID Name FROM PatientDim What does this query return? select one of the following: A. Nothing because the query won't run.B. The column PatientEpicId and name from the table PatientDimC. The PatientEpicID column from the table PatientDim, with an alias of name.D. The name column from the table PatientDim, with an alias of PatientEpicId
Assume you have these table CREATE TABLE Student (studid Char(9) Primary Key,FirstName Varchar2(50) NOT NULL,LastName Varchar2(50) NOT NULL,Email Varchar2(50) NOT NULL UNIQUE,PhoneNumber Number(8) NOT NULL UNIQUE,DateOfBirth Date NOT NULL,GPA Number(1,2) NOT NULL); CREATE TABLE Club (clubID Number(3) Primary Key,ClubName Varchar2(20) NOT NULL,studid Char(9) NOT NULL UNIQUE, Foreign key(studid) references Student(studid)); CREATE TABLE MemberOf (ClubID Number(3) Primary Key, Studid char(9), JoiningDate date, Foreign Key(ClubID) references club(clubID), Foreign Key(Studid) references Student(studid)); CREATE TABLE Activities (Actid Number(3) Primary Key,Acdt DATE NOT NULL,Place Varchar2(50) NOT NULL,durationNbHour Number NOT NULL); CREATE TABLE Organize (actid Number(3) Primary Key, clubID Number(3), Fee Number(4,2), Foreign Key(actid) references Activities(Actid),Foreign Key(clubID) references MemberOf(ClubID)); Write in SQL queries to populate the above tables by inserting minimum 4…