Курсовая работа: Создание базы данных для организации
VIEW:
CREATE VIEW
BESTCLIENT(FIO)
AS
select FIO
from client where id_c =(select cl from(select deal.cl_id as cl, count (cl_id)
as col from deal group by deal.cl_id HAVING count (cl_id) >=All (select
count (cl_id) as col from deal group by deal.cl_id)));