Question

Check the file: Questions.pdf

Solution Preview

This material may consist of step-by-step explanations on how to solve a problem or examples of proper writing, including the use of citations, references, bibliographies, and formatting. This material is made available for the sole purpose of studying and learning - misuse is strictly forbidden.

Q1
SELECT BOOKS.BTitle, BOOKS.TotalSales
FROM AUTHORS, BOOKS
WHERE (((BOOKS.TotalSales)>10000))
ORDER BY BOOKS.BTitle DESC;

Q2
SELECT AUTHORS.AuName, AUTHORS.City, AUTHORS.State, AUTHORS.Country, AUTHORS.BirthDate
FROM AUTHORS
WHERE (((AUTHORS.Country)="Canada"))
ORDER BY AUTHORS.BirthDate DESC;

Q3
SELECT BOOKS.BookID, BOOKS.BTitle, BOOKS.TotalSales, ORDERS.Price, [BOOKS]![TotalSales]*[ORDERS]![Price] AS [Revenue $], ORDERS.ODate, Count(ORDERS.Shipper) AS CountOfShipper
FROM BOOKS INNER JOIN ORDERS ON BOOKS.BookID = ORDERS.BookID
GROUP BY BOOKS.BookID, BOOKS.BTitle, BOOKS.TotalSales, ORDERS.Price, [BOOKS]![TotalSales]*[ORDERS]![Price], ORDERS.ODate
HAVING ((([BOOKS]![TotalSales]*[ORDERS]![Price])>10000) AND ((ORDERS.ODate)>=#1/1/2012#));...

This is only a preview of the solution. Please use the purchase button to see the entire solution

$20.00

or $1 if you
register a new account!

Assisting Tutor

Related Homework Solutions

E-R Diagram
Homework Solution
$25.00
Computer
Science
E-R Diagram
Database
Development
Customer
Service
Installation
Database System Concepts
Homework Solution
$55.00
Transaction
Atomicity
Consistency
Isolation
Durability
Schedule
Dirty
Read
Serializable
Strict
2Pl
Action
Object
Concurency
Control
Interference
Data
Model
Relational
Hierarchical
Network
Object-oriented
Single
Multi
User
Centrali
Questions about Oracle 11g
Homework Solution
$18.00
Computer Science
Oracle 11g
Database
System Privilege
Block Size
SQL
Tunning
SYSAUX
PFILE
SPFILE
Data Mining and Warehouse Assignment
Homework Solution
$20.00
Flight
Data
Warehouse
OLAP
Dimension
Fact
Table
Cube
Operation
Business
Time
Arrival
Star
Schema
Doctor
Patient
SQL
Query
Relational
Database
Departure
Traveler
Roll-up
Select
Get help from a qualified tutor
Live Chats