Consultas Sql Sobre Pubs

1. select * from titles

2. select title_id, title, type from titles order by title

3. select title_id, title from titles where type ='business' order by title_id desc

4. selecttitles.title_id, titles.title from titles, sales where sales.ord_date = '15/06/1992' and titles.title_id=sales.title_id

5. select au_fname, au_lname from authors,titleauthor where title_id = 'bu1032' andauthors.au_id = titleauthor.au_id

6. select sales.title_id, titles.title from titles,sales,stores where stores.stor_id='7067' and sales.stor_id=stores.stor_id and sales.title_id=titles.title_id

7.select title_id, title from titles where price between 10 and 20 and type='business' order by title

8. select au_lname,au_fname,phone from authors where state='ca' and city<>'oakland' order byau_lname,au_fname

9. select emp_id,lname,fname from employee,publishers where publishers.pub_id <>0877 and employee.pub_id=publishers.pub_id order by emp_id desc

10. selectemployee.lname,employee.fname,jobs.job_desc,publishers.pub_name from employee,jobs,publishers where publishers.pub_id=employee.pub_id and employee.job_id=jobs.job_id order by employee.lname,employee.fname

1a.select tabla1.title_id, tabla1.title from titles as tabla1,sales as tabla2,stores as tabla3 where tabla3.stor_id='7067' and tabla3.stor_id=tabla2.stor_id and tabla2.title_id=tabla1.title_id

1b. selecttitle_id as codigo_titulo, title as nombre_titulo from titles where price between 10 and 20 and type='business' order by title

1c. select au_lname as primer_apellido,au_fname as primer_nombre,phoneas telefono from authors where state='ca' and city<>'oakland' order by au_lname,au_fname

1d. select emp_id as codigo_empleado,lname as primer_apellido,fname as primer_nombre from employee astabla1,publishers as tabla2 where tabla1.pub_id <>0877 and tabla1.pub_id=tabla2.pub_id order by emp_id desc

1e. select tabla1.lname,tabla1.fname,tabla2.job_desc,tabla3.pub_name from...