FROM Salespeople
1)
2)
3)
4)
- SELECT, rating name , San Jose
1) SELECT rating, cname FROM Customers WHERE city San Jose
2) SELECT rating FROM DISTINCT WHERE city San Jose
3) SELECT rating, cname FROM DISTINCT WHERE city San Jose
4) SELECT rating, cname FROM Customers
- SELECT DISTINCT snum FROM Orders :
1) snum ,
2) snum ,
3) Customers
4) snum
- ,
1)
2)
3)
4) SQL
- ,
1)
2)
3)
4) SQL
- SELECT* FROM Orders WHERE amt>1000 :
1) $1000
2) $1000
3) Orders
4)
- London , .10
1) SELECT sname, city FROM Salespeople WHERE city=London AND comm>.10;
2) SELECT sname, city FROM DISTINCT WHERE city=London AND comm>.10;
3) SELECT sname, city FROM DISTINCT WHERE city=London
4) SELECT * FROM Salespeople WHERE city=London AND comm>.10
- SELECT*FROM Customers WHERE rating>100 OR city=Rome
1) rating>100 Rome
2) rating>100, , Rome
3) rating<100, , Rome
4) rating>100 Rome
- SELECT* FROM
1)
2)
3)
4)
- SELECT* FROM Orders WHERE odate IN (10/03/1990,10/04/1990)
1) , 3 4 1990
2) 4 1990
3) , 3 4 1990
4)
- SELECT*FROM Customers WHERE snum IN (1001,1004)
1) , PEEL Motika.
2) , PEEL Motika.
3) ,1000>max
4) , PEEL Motika
- SELECT*FROM Customers WHERE cname BETWEEN A ANDH
1) A H.
2) A H
3) A H
4) H
|
|
191. , , C.
1) SELECT* FROM Customers WHERE cname LIKEC%
2) SELECT* FROM Customers WHERE IN C% ;
3) SELECT*FROM Customers WHERE cname BETWEENC% ;
4) SELECT* FROM Customers WHERE cname=C%
- SELECT*FROM Orders WHERE amt< > 0 AND (amt IS NOT NULL) , amt
1) 0 NULL
2) 0 NULL
3)
4)
- SELECT COUNT(*) FROM Orders WHERE odate =10/03/1990
1) 3 1990
2) 3 1990
3) 3 1990
4) 10
- SELECT COUNT (DISTINCT city) FROM Customers
1) NULL Customers
2) NULL Customers
3) NULL Customers
4)
- SELECT cnum,MIN (amt) FROM Orders GROUP BY cnum
1)
2)
3)
4)
- SELECT city MAX (rating) FROM Customers GROUP BY city
1)
2)
3)
4)
- SELECT odate, count (DISTINCT snum) FROM Orders GROUP BY odate:
1) ,
2) ,
3)
4)
- SELECT odate, SUM (amt) FROM Orders GROUP BY odate ORDER BY 2 DESC .
1) .
2) .
3)
4)
- Access .
1) ,
2) , ,
3) -,
4) ,
- Access .
1) , ,
2) ,
3) -,
4) ,
174. SELECT?
5)
6)
7)
175.
SELECT*
FROM Customers
WHERE NOT rating>100
OR city=Rome;
5) Customers, ,
rating>100, , Rome
6) Customers, ,
rating>100, , Rome
- , ?
1) SELECT DISTINCT snum
|
|
FROM orders
5) SELECT DISTINCT Orders
FROM snum
6) SELECT onum
FROM Orders
- SELECT onum, amt, odate
FROM Orders
5) , Orders
6) , Order
7) , Order
- SELECT*
FROM Customers
WHERE snum=1001
5) Customers, 1001
6) Customers, 1001
7)
SELECT city, sname, snum, comm.
FROM Salespeople
5) Salesperson
6) Salesperson
7)
- SELECT, rating name , San Jose?
5) SELECT rating, cname
FROM Customers
WHERE city San Jose
6) SELECT rating
FROM DISTINCT
WHERE city San Jose
7) SELECT rating, cname
FROM DISTINCT
WHERE city San Jose
- ?
SELECT DISTINCT snum
FROM Orders;
5) snum , Orders,
6) snum , Orders,
7) Customers
- ?
1)
2)
3)
- , , , , ?
5)
6)
7)
SELECT* FROM Orders WHERE amt>1000
5) $1000
6) $1000
7)
- London , .10
1) SELECT sname, city
FROM Salespeople
WHERE city=London
AND comm>.10;
2) SELECT sname, city
FROM DISTINCT
WHERE city=London
AND comm>.10;
3) SELECT sname, city
FROM DISTINCT
WHERE city=London
SELECT*
FROM Customers
WHERE rating>100
OR city=Rome;
1) Customers, ,
rating>100, , Rome
2) Customers, ,
rating<100, , Rome
3) Customers, ,
rating>100, , Rome
- SELECT*?
1)
2)
3)
SELECT*
FROM Orders
WHERE odate IN (10/03/1990,10/04/1990);
1) , 3 4 1990
2) 4 1990
3) , 3 4 1990
SELECT*
FROM Customers
WHERE snum IN (1001,1004);
1) , PEEL Motika.
2) , PEEL Motika.
3) ,1000>max
SELECT*
FROM Customers
WHERE cname BETWEEN A ANDH;
1) ,
A H.
2) , A H
|
|
3) , A H
- , ,
C.
1) SELECT*
FROM Customers
WHERE cname LIKEC%
2) SELECT*
FROM Customers
WHERE C%;
3) SELECT*
FROM Customers
WHERE cname LIKEC%;
SELECT*
FROM Orders
WHERE amt< > 0
AND (amt IS NOT NULL)
1) , amt 0 NULL
2) , amt 0 NULL
3)
SELECT COUNT(*)
FROM Orders
WHERE odate =10/03/1990;
1) 3 1990
2) 3 1990
3) 3 1990
SELECT COUNT (DISTINCT city)
FROM Customers;
1) ( NULL) Customers
2) NULL Customers
3) NULL Customers
SELECT cnum,MIN (amt)
FROM Orders
GROUP BY cnum
1)
2)
3)
SELECT city
MAX (rating)
FROM Customers
GROUP BY city;
1)
2)
3)
SELECT odate, count (DISTINCT snum)
FROM Orders
GROUP BY odate;
1) ,
2) ,
3)
SELECT odate, SUM (amt)
FROM Orders
GROUP BY odate
ORDER BY 2 DESC;
1)
.
2)
.
3)