A retailer of computers maintains a record containing the following information for every individual computer sold. • Manufacturer name • Model number Physical memory size • Processor name • Date of sale • Price sold for Using only the database, which of the following CANNOT be determined? The most popular model of computer sold by the retailer Which models of computer stocked by the retailer have not had a single sale O The average price of a computer was sold by the retailer In which months less than 100 computers were sold

A retailer of computers maintains a record containing the following information for every individual computer sold. • Manufacturer name • Model number Physical memory size • Processor name • Date of sale • Price sold for Using only the database, which of the following CANNOT be determined? The most popular model of computer sold by the retailer Which models of computer stocked by the retailer have not had a single sale O The average price of a computer was sold by the retailer In which months less than 100 computers were sold

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

Using the database schema attached, write SQL query for these statements: (1) List stores with more than 200 customers. (2) Display the average amount paid by each customer, along with the customer's first and last name.
SQL BITS List client number, balance, consultant number, and consultant last name of every client whose balance is greater than that of client number '405.'
List all active students in June by name. (Make up names and other data if you are actually building a prototype database.) Include the number of hours students received tutoring and how many lessons they completed.
How are keywords used in SQL queries to retrieve specific data from a database?
I need help with the SQL query for the following question: 1. What is the total number of reviews in every zip code. Here is the information on the field names: The table name is: Reviews Review Form Fields Product/ModelName: Product/Category: Product/Price: Retailer/Name: Retailer/ZipCode: Retailer/City: Retailer/State: Product/On Sale: Manufacturer/Name: Manufacturer/Rebate: Review/UserId: Review/Rating: Review/Date: Review/Text: Example of Review Form Filled out ProductModelName: Galaxy S4 ProductCategory: Smart Phone ProductPrice: 499 RetailerName: Bestbuy RetailerZipCode: 44114 RetailerCity: Cleveland RetailerState: OH ProductOnSale: No ManufacturerName: Samsung ManufacturerRebate: No ReviewUserId: xmm473 ReviewRating: 3 ReviewDate: 6/10/2012 ReviewText: overheats after 2 hours
database HR list the last name and salary of employees who earn between $5,000 and $12,000, and are in department 20 or 50. Label the columns Employee and Monthly Salary, respectively.
SQL Database Write PL/SQL or T-SQL procedures to retrieve and output the reservation ID, trip ID, number of persons, and trip price for every reservation whose customer number is stored in I_CUSTOMER_NUM
List the number of albums for each artist. Only include artists with more than 5 albums. table of database Artist (ArtistId, Name) Album (AlbumId, Title, ArtistId, Year) Track (TrackId, Name, AlbumId, ArtistId, GenreId, Year) Genre (GenreId, Name)
Display the salesperson name, product finish, and total quantity sold (label as TotSales) for each finish by each salesperson.
Answer the following questions using SQL statements. a) Display the IDs and names of all instructors who have never taught a course. b) Show the names of the students whose names include substring 'cr' twice or end with 'ng'. c) Find the IDs, names of all the students who take more than 10 credits in a semester. d) Show IDs and names of the students if they do not take any course that is offered by the 'CSCI' department. e) For each department, show both the department budget and the remaining department budget after paying all its instructor's salaries. f) Show the ID of the students having taken the most courses offered by the 'CSCI' department.
Based on the ERD below, display the first and last names, hire dates, and number of years employed for all employees who have worked for the organization more than 15 years. Order by the most recent hire date.