Zoo tutorials:
[
SQL
|
SQLzoo.cn
|
Linux
|
Java
|
XML
]
Using:
SQL
zoo.net
Enter your search terms
Submit search form
Web
SQLzoo.net
Quick Ref.
SELECT
Functions
SELECT
WHERE
SELECT
GROUP BY
SELECT
JOIN
SELECT
SELECT
INSERT
VALUES
INSERT
SELECT
UPDATE
DELETE
CREATE
TABLE
CREATE
VIEW
CREATE
INDEX
DROP
ALTER
table
Functions
date
number
string
Data Types
date
number
string
AdventureWorks: easy questions
1.
Show the first name and the email address of customer with CompanyName 'Bike World'
Results
2.
Show the CompanyName for all customers with an address in City 'Dallas'.
Results
3.
How many items with ListPrice more than $1000 have been sold?
Results
4.
Give the CompanyName of those customers with orders over $100000. Include the subtotal plus tax plus freight.
Results
5.
Find the number of left racing socks ('Racing Socks, L') ordered by CompanyName 'Riding Cycles'
Results
