Question: Use tables TI and T2 in this exercise too. Create another table called T3Gobdesc, minpay).Let minpay be type NUMBER(6,2). Populate the table with at least

Use tables TI and T2 in this exercise too. Create another table called T3Gobdesc, minpay).Let minpay be type NUMBER(6,2). Populate the table with at least one occurrence of each jobdesc from table T2 plus one more jobdesc that is not in T2. Write and display the result of a triple equi-join of T1, T2, and T3. Use an appropriate comment on each of the lines of the WHERE clause where there are equi-join conditions. Note that you will need two equi-join conditions. 3-3. How many rows did you get in the equi-join? b. Use the COUNT() function and display the number of rows (rows) in the equi-join. c. How many rows would you get in this triple Cartesian product? (use COUNTC*)). d. In an equi-join of N tables, you always have a. equi-join conditions in the WHERE clause
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
