Some rows of the tables SALESPERSON and SALES are shown belo…

Some rows of the tables SALESPERSON and SALES are shown below:   SALESPERSON VCODE NAME 7 Alex 8 Tony 9 Charles 11 Mary     SALES SCODE VCODE TOTAL 341 9 19.50 213 11 89.95 312 7 31.10 You want the name of all the salespersons that have made at least one sale with a total higher than 100.   Which of the following queries gives the desired result?  

Consider the following table Table name: TENANT | ID | NAME…

Consider the following table Table name: TENANT | ID | NAME | RENT | | 18 | Alex | 219 | | 31 | Rose | 250 | | 77 | Alex | 300 | | 41 | Mary | 280 | | 81 | Rose | 240 | Which query returns the following? | ID | NAME | RENT | | 18 | Alex | 219 | | 81 | Rose | 240 | | 31 | Rose | 250 | | 41 | Mary | 280 | | 77 | Alex | 300 |