MYSQL Lab List Solutions

1.       select * from route_header where origin='madras' and destination='cochin';

2.       update route_header set distance=300 where origin in('madras','madurai') and destination in('madras','madurai');

3.       delete from route_header where origin = 'madras' and destination = 'bangalore';

4.       select * from route_header where origin like 'm%';

5.       select * from route_header where fare between 30 and 50;

6.       select fare,origin from route_header where route_no>15;

7.       select * from place_header where place_name like 'm%';

8.       select * from place_header where place_name like 'a%';

9.       create table pseudo as (select * from category_header);

10.   select add_months(doi,2) from ticket_header;

11.   select last_day(dot) from ticket_header;

12.   select months_between(dot,doi) from ticket_header;

13.   select next_day(dot,'friday') from ticket_header;

14.    

                                   I.            select round(to_date(day,'dd-mon-yy'),'year') from fleet_header;

                                 II.            select round(to_date(day,'dd-mon-yy'),'month') from fleet_header;

                               III.            select round(to_date(day,'dd-mon-yy'),'day') from fleet_header;

                               IV.            select round(to_date(day,'dd-mon-yy')) from fleet_header;

15.    

                                      I.            select trunc(to_date(day,'dd-mon-yy'),'year') from fleet_header;

                                    II.            select trunc(to_date(day,'dd-mon-yy'),'month') from fleet_header;

                                  III.            select trunc(to_date(day,'dd-mon-yy'),'day') from fleet_header;

                                  IV.            select trunc(to_date(day,'dd-mon-yy')) from fleet_header;

16.   select greatest(to_date(doi),to_date(dot)) from ticket_header;

17.   select day+31 from fleet_header;

18.   select day-60 from fleet_header;

19.    select concat(upper(left(name,1)),substring(name,2)) from ticket_detail;

20.   select upper(name) from ticket_detail;

21.   select lower(place_name) from place_header;

22.   select rtrim(place_name,'galore') from place_header where place_name='bangalore';

23.   select ltrim(place_name,'hydera') from place_header where place_name='hyderabad';

24.   select translate(place_name,'m','v') from place_header where place_name like 'm%';

25.   select substr(name,3,3) from ticket_detail;

26.   select replace(place_name,'a','e') from place_header;

27.   select round(total_fare,2) from ticket_header;

28.   select floor(total_fare) from ticket_header;

29.   select to_char(sysdate,'ddth "of" fmmonth yyyy')) from dual;

30.   select to_char(september 20 1996,'month-dd-yyyy')) from dual;

31.   insert into category_header(cat_code) values(80);select nvl(cat_desc,0) from category_header;

32.   select avg(total_fare) from ticket_header;

33.   select name from ticket_detail where fare=(select max(fare) from ticket_detail);

34.   select * from route_header where distance=(select min(distance) from route_header);

35.   select sum(total_fare) from ticket_header;

36.   select name,count(name) from ticket_detail group by name;

37.   update (tablename) set day=’wednesday’ where day=’sunday’