lesphomework

this is a crazy site for crazy people

Tuesday

section 3 lesson 2

1 select *from d_play_list_items,d_track_listings
2 select *from d_play_list_items,d_track_listings
where d_play_list_items.song_id=d_track_listings.song_id
3 select d_songs.title, d_songs.artist, d_types.description from d_songs,d_types
4 select d_songs.title, d_songs.artist, d_types.description from d_songs,d_types
where id in (47,48)
5 select * from d_clients , d_events, d_job_assignments
6. select d_track_listings.song_id, d_cds.titlefrom d_track_listings, d_cds

section 2 4

select first_name,last_name,zip
from F_CUSTOMERS
where length(zip)<10

Sunday

lesson 4

1.select ROUND(86.678,-2) from dual
2.select upper(title) from where cd_number in (90,91)
3.select last_nameupper(substr(first_name,1,1)) as "User Passwords" from
4.select LOWER(REPLACE('It's a small world', 'It's a small','hello')) from dual
5. select substr('fiddledeedum',10,3)substr('fiddledeedee',1,6) from dual
6. select replace('Mississippi','i','$') from dual
7. select round(5332.342,3) from dual
8. select round(3.14159,-2) from dual
9. select trunc(73.892,-1) from dual
10. select next_day(add_mounths(sysdate, 6),'Firday') from dual
11. select add_months(sysdate,120) as "Future" from dual
12. select add_months('29-FEB-04',48) as "Future" from dual
13. select themes from where themes="%ie%"14. select title, year from where year between 2000 and 2003