Question

• Query 3: Update the Shelf_Location to KD-2222 for books of a Subject_Code that has the least number of books. For example, if ART and PHL subjects each contains only two books and all other subjects have three or more books, then the Shelf_Location of four books of ART and PHL should be updated. Hint: subquery
• 
  ISBN Publisher Hill and Wang The Dryden Press Vintage Dell Publishing Wamer Books Wamer Books Wamer Books Subject_Code Sheit_Location Fiction HMR BSN Beck, Fred Millspaugh, A. C. Hirsch, E. D. Jr. Steel, Daniells Naisbitt, John Waller, Robert James RC-1111 RC-1111 RC-1115 RC-1114 RC-1114 20-15-500139-6 Business Programming in C 3 0-394-75843-9 Cultural Literacy 4 0-440-22284-2 Five Days in Paris 50-446-51251-6 Megatrends 6 0-446-51652-X Bridges of Madison County 7 0-446-60274-4 The Rules 8 0-451-16095-9 The Stand 90-452-26011-6 Song of Solomon 10 0-517-59905-8 How to Talk to Anyone, Anytime, Anywhere King, Lany 11 0-534-26076-4 AQuick Guide to the Intemet 12 0-553-24484-X Prospering Womarn 13 0-670-85332-1 How to be Hap-Hap-Happy Like Me 14 0-671-66398-4 Seven Habits of Highly Effective People Covey, Stepehn R. Fireside 15 0-671-67158-8 Time Wars 16 0-697-12897-0 QuickBasic and QBasic Using Modular St Bradey, Julia Case B & E Tech 17 0-697-21361-7 Desktop Publishing Using PageMaker 5.0 Bradey, Julia Case B & E Tech 18 0-8007-1213-7 Secrets of Closing the Sale 19 0-8041-0753-X The Kitchen God's Wife 20 0-8109-3158-3 Thomas Cole 21 0-8109-8052-5 The Art of Walt Disney 22 0-8487-0504 Erica Wilson's Quilts of America 23 0-87826-2 240-89997-087-7 Afoot and Afield in Orange County PHL BSS RC-1111 RC-1113 RC-1114 RC-1113 RC-1111 RC-1111 RC-1113 RC-1111 RC-1115 RC-1112 RC-1111 RC-1112 RC-1113 MST BSS SLH BSN King, Stephen Plume/Penguin Bradley, Julia Case Ross, Ruth Markoe, Memil Integrated Media Group Bantam Books HMR BSN PHL BSN Rifkin, Jeremy Simon and Schuster BSN lvy Books Powell, Earl A Finch, Christopher Wilson, Erica Schneider, Ear Schad, Jemy Abradale Oxmoor House The Pet Library LTD Wildemess Press RC-1112 RC-1112 RC-1112 RC-1112 Know Your Lhaso Apso SLH 0-915391-40-6 Desianina User Interfa
  

Answer 1

Update Book inner join (Select Subject_Code from Book group by Subject_Code having count(ISBN) = min(count(ISBN)) s on Book.Subject_Code = s.Subject_Code set Shelf_Location = 'KD-2222';

Do ask if any doubt. Please upvote.