База данных
1. "Операции сотрудников"
//вывод всех операций сотрудника
SEL ECT * FR OM `torgovye_operacii` WHERE `sotrudnik` = "Петров"
//сортировка всех операций сотрудника по дате
SEL ECT * FR OM `torgovye_operacii` WHERE `sotrudnik` = "Петров" ORDER BY date DESC
//средняя сумма и гонорар сотрудника
SEL ECT `sotrudnik`, AVG(`summa`) as summa, SUM(`gonorar`) as gonorar FROM `torgovye_operacii` GROUP BY `sotrudnik`
2. "Операции по видам"
SEL ECT `vid_operacii`, AVG(`summa`) as summa FROM `torgovye_operacii` GROUP BY `vid_operacii`
3. "Операции по годам"
SELECT `vid_operacii`, SUM(`summa`) as summa, YEAR(`date`) as year FR OM `torgovye_operacii` GROUP BY `vid_operacii`, YEAR(`date`)
4. "Отчет по годам"
SELECT `sotrudnik`, SUM(`gonorar`) as gonorar, SUM(`summa`) as summa, YEAR(`date`) as year FR OM `torgovye_operacii` GROUP BY `sotrudnik`, YEAR(`date`)
5. "Отчет за 1998 год"
SELECT `vid_operacii`, SUM(`summa`) as summa FR OM `torgovye_operacii` WH ERE YEAR(`date`) = "1998" GROUP BY `vid_operacii`