Region PaymentEastPaypalWestCreditNorthCreditWestSouthWestEastWestWestSouthSouthEastNorthEastWestWestEastWestNorthWestPaypalCreditPaypalCreditCreditPaypalPaypalPaypalCreditPaypalCreditCreditPaypalPaypalPaypalPaypalCreditSourceWebWebWebEmailWebEmailWebWebWebWebEmailWebWebWebWebWebWebWebEmailWebAmount20.5516.1122.2422.4315.5918.26176.9322.5917.3422.3627.9820.1720.36150.3720.8222.8619.6520.3917.3517.79ProductDVDDVDBookDVDBookBookDVDDVDBookBookDVDBookBookBookDVDBookBookDVDBookDVD0 In the accompanying Sales Transactions data, use Excel's filtering capability to extracta. all orders that used Paypal.b. all orders under $100.c. all orders that were over $100 and used a credit card.Click the icon to view the sales transactions.a. Complete the table to show the amounts of all orders that used Paypal.EProductDVDDVDBookBookBookDVDBookBookBookDVDBook12379101112ARegionEastWestWestWestSouthSouthNorthWestEastWestNorthBPaymentPaypalPaypalPaypalPaypalPaypalPaypalPaypalPaypalPaypalPaypalPaypalCSourceWebEmailEmailWebWebEmailWebWebWebWebEmailDAmount

Below I have provided the solution of the given question

In the accompanying Sales Transactions data, use Excel's filtering capability to extract a. all orders that used Paypal. b. all orders under $100. c. all orders that were over $100 and used a credit card. Click the icon to view the sales transactions.

In the accompanying Sales Transactions data, use Excel's filtering capability to extract a. all orders that used Paypal. b. all orders under $100. c. all orders that were over $100 and used a credit card. Click the icon to view the sales transactions.

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

Similar questions

QUESTION 4 Which of the following are true (CHECK ALL THAT APPLY!) See the first item under DataSets in Blackboard. (bankinglnfo.csv and the notes about all the columns) One of these answers refers to that dataset. Please note that there are three questions in this sample quiz that refer to this dataset. O A line plot is good to use when viewing how a variable changes over time. O Multiple lines can be plotted on the same figure when using matplotlib. O The bank data set in the questions on this sample quzi is a good example of a dataset that can be visualized with a line plot. O Visualization can often show underlying structure of the data. QUESTION 5 Which of the following is true of matplotlib? O matplotlib does not allow customization of plots O matplotlib is a python library for plotting O matplotlib is the only library available for plotting line graphs O matplotlib does not work well with numpy arrays
The InstantRide User Satisfaction team requires the average and maximum number of rides users have taken so far with InstantRide. In addition, they would like to know the total number of travels. However, they need these details with the corresponding column names Average, Maximum and Total by using the AVG, MAX and SUM functions. In order to accomplish this, you will first need to create a derived table from the TRAVELS table to pass the TRAVEL_ID count to the three mathematical functions.
Task 2: StayWell is an active business and already has some data collected over e-mails and phone conversations. You need to insert the following data to the OWNER and PROPERTY tables: Add the provided information to the OWNER table. Add the provided information to the PROPERTY table.
Create lookup functions to complete the summary section. In cell I6, create a formula using the VLOOKUP function to display the number of hours worked in the selected week. Look up the week number in cell I5 in the range A17:G20, and return the value in the 2nd column. Use absolute references for cell I5 and the range A17:G20.
Enter the data provided below into Excel in a column (for example A1:A8). Copy the data and transpose it where the leftmost cell is H1. What is the value in L1? 10, 20, 41, 57, 33, 51, q53, 23
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
1. Use the fill handle to create two lists of percentages: (a) 4.00% through 13.00% in increments of 0.50% in the range I5:I23 and (b) 4.00% through 11.00% in increments of 1.00% in the range J4:Q4. 2. Use the Data Table button in the What-If Analysis gallery (Data tab | Forecast group) to define the range I4:Q23 as a two-input data table. Enter C8 in the ‘Row input cell’ box and C5 in the ‘Column input cell’ box (Data Table dialog box). Click OK to populate the table. 3. Format the two-input data table using a White, Background 1 font color and the fill color used in cells B3:G12. Bold ranges I4:Q4 and I5:I23. Format cells J5:Q23 to match the number format used in cells F5:G12. Place a light style border around the range I3:Q23, light style borders between columns in that same range, and a light style bottom border on the range I4:Q4. 4. Protect the worksheet so that the user can select only unlocked cells (C3:C6 and C8:C9). *Complete the following using Excel based off the document…
The incomplete box plot and table show some information about some marks. Use the information in the table to complete the box plot. Use the information in the box plot to complete the table.
Create a view to show the total number of staff for each city with more than 1 staff. The output column header should be city, number_of_staff, sorted by the total number of staff from high to low.
5. Open the UnsoldComponents query and complete the following tasks: a. Delete the criteria row that contains criteria in the InstallationFee field. b. Add the ClientID field from the ClientSoftware table to the query grid in the fourth column. С. Set the query to select all records from the SoftwareComponent table. d. Select only those records from the SoftwareComponent table with no matching records in the ClientSoftware table. Save and close the UnsoldComponents query. The query should match Figure 2 when in Datasheet view.
CREATE TABLE consumer ( ConsumerID INT PRIMARY KEY, FirstName VARCHAR(50), LastName VARCHAR(50), Age INT, Gender VARCHAR(10), OnlineInStore VARCHAR(20)); INSERT INTO consumer (ConsumerID, FirstName, LastName, Age, Gender, OnlineInStore) VALUES (1, 'John', 'Doe', 25, 'Male', 'Online');INSERT INTO consumer (ConsumerID, FirstName, LastName, Age, Gender, OnlineInStore) VALUES (2, 'Jane', 'Smith', 30, 'Female', 'In-store');INSERT INTO consumer (ConsumerID, FirstName, LastName, Age, Gender, OnlineInStore) VALUES (3, 'Mike', 'Johnson', 20, 'Male', 'Online');INSERT INTO consumer (ConsumerID, FirstName, LastName, Age, Gender, OnlineInStore) VALUES (4, 'Sarah', 'Williams', 35, 'Female', 'In-store');INSERT INTO consumer (ConsumerID, FirstName, LastName, Age, Gender, OnlineInStore) VALUES (5, 'Chris', 'Davis', 28, 'Male', 'Online'); CREATE TABLE InStoreRetailer ( RetailerID INT PRIMARY KEY, RetailerName VARCHAR(50), StoreLayout VARCHAR(50), CustomerService…