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

Assisting Tutor

Related Homework Solutions

Database Development Questions
Homework Solution
$40.00
Computer Science
Database Development
SQL Queries
Models
Tables
Relational Calculus
Relational Algebra
Flights
Employees
Airline Information
Foreign Key
Primary Key
Constraints
Unsafe Queries
Relational Algebra and Database Development
Homework Solution
$20.00
Computer Science
Relational Algebra
Database Development
Tables
Relationships
Publishers
Books
Conditions
Authors
Contact Information
SQL Server for Business Intelligence
Homework Solution
$20.00
SQL
Server
Business
Intelligence
Transactional
3rd
Normal
Form
Relational
Schema
Dimensional
Model
Fact
Table
OLAP
System
Warehouse
Database
Analysis
Services
Data
Tools
Management
Studio
Dimension
SQL Server Installation Report
Homework Solution
$20.00
SQL Server
Installation
How To
Guide
Computer
Science
Database
Development
Murach
Script
Management
Database Normalization Problems
Homework Solution
$40.00
Computer Science
SQLite
Database Normalization
ER Diagrams
Drawing Tools
Relationships
Tables
Primary Key
Foreign Key
Spreadsheet Design
Columns
Rows
Dependency
Get help from a qualified tutor
Live Chats