� �

���

�

��� ��� ��������������������������! "���$#&%����' � ��� ������������&()�$�*�+�,���-�.%��/� �%��0�21&��! "%,�,�3��%��

�4���� ���3��! "�����

5

687:9<;:=?>A@:BC9D=�E-=?9DF:G:9D@3HJIK<L:K =�HJ7 K H&IM9DNANAIOHJ7:9L 9D9D=?P

Q

�

R

�

�

S T

SELECT DISTINCT price

FROM Sells;

U

V

(SELECT drinker FROM Frequents)

EXCEPT ALL

(SELECT drinker FROM Likes);V

��W

�

�$�

V

V

V

Likes NATURAL JOIN Serves;V

���

V

V

Drinkers JOIN Frequents ON

name = drinker;

���

X Y�Z�[ �]\_^"%��`�8%���a�������ab�3+�^8� ��.1�(<c`1&��� d��X c8eMfhg&�]\_^"%��`�8%��ia�������ab�3+�^8� ���1�(kjl1&��� d��X [nmoYiY \p^"%��q "1��3�Or,�3��� �.s���1&� s:t� ���3�� ���(u%�+�� �3�

��5

� Q

SELECT AVG(price)

FROM Sells

WHERE beer = ’Bud’;

��R

V

V

SELECT COUNT(DISTINCT price)

FROM Sells

WHERE beer = ’Bud’;

� S � T

687:9<@:G:v L 9D=�wxE L:K =$IHJ7 K H,IM9DNAN0y�G:;:P

687:9<@:G:v L 9D=�wxE L:K =$IHJ7 K H,IM9DNAN0y�G:; K H KBC@:wxz{@}|:=?>A~x9DP

��U �$W

SELECT beer, AVG(price)

FROM Sells

GROUP BY beer;

���

V

� w0v<|:G3HJ9;:=?>A@:BC9D=?� L:K =?�|:=?>A~x9<wxE�y�G:;HJG:|:NA9DIOE->A=?I�HJ�HJ7:9D@}�:=?w0G:|L3� ;:=?>A@:BC9D=?P

�$�

�$�

�

�$5

� Q

��� �ta��$1&+�^8����ab%��-������ 8+i�-�#&1&�' � �,a8a��$�a8%��-����

�$R

� S

y�9D9D=?Ikv K @:G:�E K ~�HJG:=?9D; L3��:9MHJ9D� IMP

y�9D9D=��:=?w0G:|:IOz{> HJ7 K H,NA9 K I�H� @:w0@:�?���8�C� L:K =?I K @:; K NAIMwL 9D9D=��:=?w0G:|:IOz{7:9D=?9�HJ7�9v K @:G3E K ~�HJG:=?9D=�>AI��:9MHJ9D� I�P

� T

�$U

INSERT INTO Likes

VALUES(’Sally’, ’Bud’);

�$W

���

INSERT INTO Likes(beer, drinker)

VALUES(’Bud’, ’Sally’);

�$�

�$� �$5

� K >A=?I�wxE��O=?>A@:BC9D=HJG:|:NA9DIOz{7:9D=?9�H�7:9E->A=?I�H,>AIOE-w0=�� K NAN � �HJ7:9<IM9D~xw0@:;}>AIOE-w0=IMw0v/9�w0@:9<9DNAIM9D�K @:;oHJ7:9 L:K =?I K =?9HJ7:9<I K v/9DP

687:9<wxHJ7:9D=;:=?>A@:BC9D=

� Q �$R

DELETE FROM Likes

WHERE drinker = ’Sally’ AND

beer = ’Bud’;

� S

DELETE FROM Likes;

� T

y�9D9D=?IOz{> HJ7oHJ7:9<I K v/9v K @:G3E K ~�HJG:=?9D= K @:;K ;:> E�E-9D=?9D@3H,@ K v/9E-=?w0v!HJ7:9<@ K v/9<wxEHJ7:9 L 9D9D=�=?9D|:=?9DIM9D@3HJ9D;L3� HJG:|:NA9 L P

�$U 5$W

5�� 5$�

UPDATE Drinkers

SET phone = ’555 - 1212’

WHERE name = ’Fred’;

5$�

UPDATE Sells

SET price = 4.00

WHERE price > 4.00;