SQL Sailors (sid: integer, sname: string, rating: integer, age: real) Boats (bid: integer, bname: string, color: string) Reserves (sid: integer, bid: integer, day: date) q1- Compute the names and maximum rating of persons who have sailed two different boats on the same day.

SQL CODE FOR  For the players who show up in Batting, Bowling, and Fielding tables, create a list that shows their names, runs they have scored, wickets they have taken, and catches they have taken? table is in picture (bowling table is same as batting and fielding )

Test 9 > run Enter x and y coordinates of the 1st circle: 1.5 0.25 Enter radius of the 1st circle: 1.2 Enter x and y coordinates of the square: 0.3 -2.5 Enter width of the square: 5 Enter x and y coordinates of the 2nd circle: 1.6 -1.1 Enter radius of the 2nd circle: 0.5 Enter x and y coordinates of the query point: 1.6 -1.55 2nd circle and square contain point (1.6, -1.55). Test 10 > run Enter x and y coordinates of the 1st circle: 1.5 0.25 Enter radius of the 1st circle: 1.2 Enter x and y coordinates of the square: 0.3 2.5 Enter width of the square: 5 Enter x and y coordinates of the 2nd circle: 1.6 -1.1 Enter radius of the 2nd circle: 0.5 Enter x and y coordinates of the query point: 1.55 -0.85 Both circles contain point (1.55, -0.85). TASK 1: Study the lecture notes (Powerpoint slides and pre-recorded lectures) and assigned readings on Selection before you start. TASK 2: Replace "??" with your name, creation date, and a description of the program (synopsis). NOTE: DO NOT…

Richardson Ski Racing (RSR) sells equipment needed for downhill ski racing. One of RSR's products is fencing used on downhill courses. The fence product comes in 150-foot rolls and sells for $215 per roll. However, RSR offers quantity discounts. The following table shows the price per roll depending on order size: Quantity Ordered To Price per Roll From 1 70 $215 71 140 $195 141 280 $175 281 and up $155 Click on the datafile logo to reference the data. DATA file (a) Use the VLOOKUP function with the preceding pricing table to determine the total revenue from these orders. (b) Use the COUNTIF function to determine the number of orders in each price bin. From Number of To Price per Roll 70 $215 !!! 140 $195 280 $175 and up $155 1 71 141 281 Orders 172