4.txt

1. SELECT SUM(AMOUNT) FROM CHALLAN WHERE OFFENCECODE = 'A111';
2. SELECT VEHICLE.REGNO,REGDATE, CH_DATE, AMOUNT FROM CHALLAN, VEHICLE WHERE CHALLAN.REGNO = VEHICLE.REGNO;
3. SELECT COUNT(*) FROM VEHICLE WHERE YEAR(REGDATE) = 2011;
4. SELECT SUM(AMOUNT), OFFENCECODE FROM CHALLAN GROUP BY OFFENCECODE;
5. SELECT REGNO, COUNT(*) FROM CHALLAN GROUP BY REGNO HAVING COUNT(*) > 2;
6. SELECT CHALLNO, CH_DATE, CHALLAN.REGNO, OFFENCECODE, AMOUNT, OWNER, ADDRESS FROM CHALLAN, VEHICLE WHERE VEHICLE.REGNO = CHALLAN.REGNO;
7. SELECT COUNT(*), CH_DATE FROM CHALLAN GROUP BY CH_DATE HAVING COUNT(*) > 2;
8. SELECT COUNT(*), CH_DATE FROM CHALLAN GROUP BY OFFENCECODE HAVING YEAR(CH_DATE) = 2012;
9. SELECT * FROM CHALLAN ORDER BY CH_DATE DESC;
10. SELECT MIN(REGDATE) AS 'FIRST REGISTRATION DATE', MAX(REGDATE) AS 'LAST REGISTRATION DATE' FROM VEHICLE;
11. SELECT COUNT(*), CH_DATE FROM CHALLAN GROUP BY CH_DATE;
12. SELECT VEHICLE.REGNO, OWNER, ADDRESS, CHALLNO, OFFENCECODE FROM CHALLAN, VEHICLE WHERE CHALLAN.REGNO = VEHICLE.REGNO;
13. SELECT COUNT(*), OFFENCECODE FROM CHALLAN GROUP BY OFFENCECODE;
14. SELECT COUNT(*) FROM VEHICLE WHERE REGNO LIKE '__09%';
15. ALTER TABLE VEHICLE ADD LOCATION CHAR(30);
16. SELECT REGNO, OWNER FROM VEHICLE WHERE OWNER LIKE '%A%';
17. SELECT COUNT(*) FROM CHALLAN WHERE CH_DATE IS NULL;
18. SELECT * FROM CHALLAN WHERE AMOUNT > 1000;
19.
DESC VEHICLE;
DESC CHALLAN;