(Solved) : Wite Check Make Sure New Row Inserted Games Table Always One Greece China Uk Chapter 8 Up Q38158171 . . .
asap please
. Wite a CHECK to make sure that any new row Inserted to the Games table is always one of Greece, China or UK. Chapter 8: a) UPPER and LOWER Functions b) ROUND and FLOOR Functions c) ADD_MONTHS and Addition by days d) SYSDATE e) Concatenate WEATHER ID CITY ST LAT N LONG W ID MONTH TEMP F RAIN I DATE I 57.4 0.31 05/12/2013 13 Phosnix AZ 33 112 131 5 13 Phoenix AZ 331121391.7 5.15 05/12/2013 | 105 144 1 27.3 0.18 05/12/2013 44 | Denver | CO | 40 44| Denver | СО 40 | 105 44 ー7 キー74.8 2.11 05/12/2013 66 Caribou ME 47 686 44 Denver CO 40 6.7 2.1 05/12/2013 66765.8 4.52 05/12/2013 66 Caribou ME 47 68 29. Write a Code to display the ID and uppercased City. 0. Write a Code to display the rounded temperature column to the nearest whole number. 31. Concatenate City and State columns to a new column called CITY STATE (use””to separate between the two values in the new column). 32. Write a code to display DATE_ I and a new column which has the date incremented by 18 days 33. Write a code to display DATE I and a new column which has the date incremented by 2 months. Show transcribed image text
Expert Answer
Answer to Wite Check Make Sure New Row Inserted Games Table Always One Greece China Uk Chapter 8 Up Q38158171 . . .
OR