there is a picture of the database attached .in sql server write a query that is able to extract mini-figures from your database but need to do so in a way that I

can name the mini figure (Darth Vader), tie it to a specific set (#75142), and get a list of the

specific parts that make up the mini figure:

Torso piece: 6077866

Leg piece: 6080459

Head piece: 6188222

Head accessory: 6112160

Accessory: 4124108 (light saber)

Group1_Minifigs PK minifigkey:Auto Number SIEK itemNumber:AutoNumber FK pieceNumber:AutoNumber FK minifigTypesKey:AutoNumbers minifigName.varchar Group1_Minifig Types PK minifig TypesKey:Auto Number type Description:varchar Ho Group1_Set-Pieces PKFK itemNumber:AutoNumbe! PKFK pieceNumber:Autonumb quantity:int Group1_Sets #PK itemNumber setName.varchar pricePaid:money isOwned:bit