With the tables given below, answer the question in SQL code. Q) Show the author

Question

With the tables given below, answer the question in SQL code.

Q) Show the author id and name whose number of published titles is higher than the lowest number of titles published by authors in CA states.

dbo.titles [Data] dbo.publishers [Data] dbo.authors [Data] SQLQueryl.sgl * To Y Max Rows: 1000 address 309 63rd St. #411 3410 Blonde St. phone 415 986-7020 415 836-7128 301 946-8853 1956 Arlington Rockville 615 996-8275 913 843-0462 415 834-2919 408 286-2428 415 836-7128 503 745-6402 707 448-4982 801 826-0752 67 Seventh Av. Salt Lake CityUT 415 585-4620 415 843-2991 5420 Telegraph Oakland 415 548-7723 589 Darwin Ln. Berkeley 415 935-4228 3 Silver Ct. 707 938-6445 219 547-9982 3 Balding Pl. 801 826-0752 67 Seventh Av. Salt Lake CityUT 415 534-9219 5720 McAuley St. Oakland 15 354-7128 408 496-7223 415 658-9932 6223 Bateman St. Berkeley au id au Iname au name Marjorie 94618 94301 20853 48105 Green Oakland Palo Alto del Castillo 2286 Cram PL # Ann Arbor 10 Mississippi Dr. Lawrence 5420 College Av. Oakland 22 Cleveland A...San Jose 3410 Blonde St. Palo Alto 55 Hillsdale BI. Corvallis 301 Putnam Smith Meander KS Michael Hunter Blotchet-Halls Reginald McBadden 95128 94301 97330 Heather Vacaville 84152 12 Locksley Charlene 18 Broadway Av. San Francisco CA 94130 inger 94705 94595 95428 46403 84152 15 Akiko Walnut Creek CA Covelo Yokomoto Gringlesby PO Box 792 Michel Albert Defrance 19 20 21 Karsen MacFeather White Bennet Greene NULL Stearns Johnson Abraham Morningstar 615 297-2723 22 Graybar Hou.. Nashville NULL 94612 94025 94705 37215 NULL 44 Upland Hts. akland 10932 Bigge Rd. Menlo Park 0 NULL NULL NULL NULL NULL

Explanation / Answer

Ans.)

Query :

select au_id,au_fname, au_lname from authors
where au_id in(select au_id from titles
group by au_id
having count(title_id)>
(select min(s.c) from (SELECT count(title_id) as c FROM titles where
au_id in(select distinct au_id from authors where state='CA')
group by au_id) as s));

Result :

au_id|au_lname|au_fname

Related Questions

Navigate

• Browse (All)
• Browse W
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.