CREATE TABLE Fielding( Player CHAR(25), CareerSpan VARCHAR(20), Matches INT, Innings INT, Catches INT, MaxCatchesInOneInning INT, CatchesPerInning NUMERIC ); 0.846); INSERT INTO Fielding VALUES('AB de villiers', '2006-2017', INSERT INTO Fielding VALUES('DA Miller', INSERT INTO Fielding VALUES('JP Duminy', INSERT INTO Fielding VALUES('GC Smith', INSERT INTO Fielding VALUES('F du Plessis', INSERT INTO Fielding VALUES('HM Amla', INSERT INTO Fielding VALUES('J Botha', INSERT INTO Fielding VALUES('JA Morkel', INSERT INTO Fielding VALUES('F Behardien', INSERT INTO Fielding VALUES('DW Steyn', INSERT INTO Fielding VALUES ('JL Ontong', INSERT INTO Fielding VALUES('RJ Peterson', INSERT INTO Fielding VALUES('RR Rossouw', INSERT INTO Fielding VALUES('D Wiese', INSERT INTO Fielding 78, 52, 44, 3, 36, 0.620); 58, 58, 3, '2010-2018', 2, 0.441); 77, 77, 34, '2007-2018', 18, 2, 0.545); '2005- 2011', 33, 33, 2, 0.500); 36, 36, 18, '2012-2017', 2, 0.439); '2009- 2018', 41, 41, 18, 2, 0.425); 40, 40, 17, '2006- 2012', 2, 0.340); 50, 50, 17, '2005- 2015', 2, 0.351); 37, 37, 13, '2012-2018', 1, 0.261); 42, 42, 11, '2007-2016', 10, 3, 0.714); 14, 14, '2008-2015', 2, 0.476); 21, 10, '2006- 2014', 21, 9, 3, 0.600); 15, 15, '2014-2016', 0.450); 20, 20, 9, '2013-2016', 3, 0.347); 23, 8, 23, '2005-2010', VALUES('HH Gibbs', 2,

Below are some rows of the PROVIDERS table for a factory:   PCODE NAME PHONE 10192 Hans, Inc. 231 - 3092 98411 Tools and More 231 - 1029 0489035 Motors Inc. 993 - 1821   All providers from the factory zone of the city start with 231. You want to get the providers that are in the factory zone of the city. Which of the following is more appropriate?     a. SELECT * FROM PROVIDERS WHERE PHONE LIKE ‘%231%’   b. SELECT * FROM PROVIDERS WHERE PHONE LIKE ‘% 231’   c. SELECT * FROM PROVIDERS WHERE PHONE LIKE ‘___ 231 ___’   d. SELECT * FROM PROVIDERS WHERE PHONE LIKE ‘231%’

SQL: Dog DataIn each question below, you will define a new table based on the following tables.CREATE TABLE parents ASSELECT "abraham" AS parent, "barack" AS child UNIONSELECT "abraham" , "clinton" UNIONSELECT "delano" , "herbert" UNIONSELECT "fillmore" , "abraham" UNIONSELECT "fillmore" , "delano" UNIONSELECT "fillmore" , "grover" UNIONSELECT "eisenhower" , "fillmore";CREATE TABLE dogs ASSELECT "abraham" AS name, "long" AS fur, 26 AS height UNIONSELECT "barack" , "short" , 52 UNIONSELECT "clinton" , "long" , 47 UNIONSELECT "delano" , "long" , 46 UNIONSELECT "eisenhower" , "short" , 35 UNIONSELECT "fillmore" , "curly" , 32 UNIONSELECT "grover" , "short" , 28 UNIONSELECT "herbert" , "curly" , 31;CREATE TABLE sizes ASSELECT "toy" AS size, 24 AS min, 28 AS max UNIONSELECT "mini" , 28 , 35 UNIONSELECT "medium" , 35 , 45 UNIONSELECT "standard" , 45 , 60; Q2: By Parent HeightCreate a table by_parent_height that has a column of the names of all dogs that have a parent,ordered by the height…

Task 3: The Car Maintenance team wants to insert and store the following maintenance types to the MAINTENANCE_TYPES table: ID: 1; Description: Tire Change; Price: 50 ID: 2; Description; Oil Change; Price: 45 ID: 3; Description; Full Cleaning; Price: 100 ID: 4; Description; Gas Pump Change; Price: 145 Add the four maintenance types to the MAINTENANCE_TYPES table.

Write a ASQ statement to return to see all of the first names in the People table. SELECT first name FROM people; WHERE FROM People first name; FROM People SELECT first_name; First name WHERE FROM People;

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

Below are some rows of the PROVIDERS table for a factory: PCODE 10192 98411 0489035 NAME Hans, Inc. Tools and More Motors Inc. PHONE 231 - 3092 231-1029 993 - 1821 All providers from the factory zone of the city start with 231. You want to get the providers that are in the factory zone of the city. Which of the following is more appropriate? O a. O b. SELECT * FROM PROVIDERS WHERE PHONE LIKE '% 231' O C. O d. SELECT * FROM PROVIDERS WHERE PHONE LIKE $231%' SELECT * FROM PROVIDERS WHERE PHONE LIKE 231 SELECT * FROM PROVIDERS WHERE PHONE LIKE '%231%'

You have been told that you need to store the zip code for employees.  Add a column to the EMPLOYEE table which will be used to store each employee’s zip code Update two rows in the EMPLOYEE table and assign a zip code (must have a WHERE clause).  (you MAY use 1 or 2 statements)  Write a query that includes each employee's last name, department name (not ID), and salary for each employee whose salary is less than the average for their department

INFO 2303  Database Programming Assignment  : PL/SQL Practice   Note: PL/SQL can be executed in SQL*Plus or SQL Developer or Oracle Live SQL.   Write an anonymous PL/SQL block that will delete all patients for doctors that works in the Family Practice Verify that patients have been deleted accordingly. Then do a select * from patients where doc_id = (select doc_id from doctor where area = ‘Family Practice’. You should get no rows.

https://www.w3schools.com/sql/trysql.asp?filename=trysql_select_all