Go to SQL Developer. Add a WHERE clause to your subquery in step 13 to filter the fee types used by the SUM. Use a SELECT... FROM FEE_TYPE WHERE... within the IN operator to do this. Include only fee types named rate and smoke damage. (Oracle is case sensitive. Your values must match what is in your FEE_TYPE table.) Refer to W3Schools - SQL IN Operator for examples. The query should return the following results.FIRSTNAME LASTNAME TOTALFEE RANKLETTERBilly Elliot 30 CJustin Hackman 160 BKristoff Kurn 840 AIn your SELECT, make table names UPPER_CASE and column names ProperCase. If you haven't already, add a comment before the query that includes your name, student number, and today's date.In SQLPLUS run CST2355_A1_FORMAT.SQL using the @ command. Clear your screen. Copy and paste into SQLPLUS to run your script.Provide a screenshot from SQLPLUS of your comment, SELECT statement, and its formatted output results.

SQL> - Query by Paramjit Singh, Student Number 0404787654, Date 3 August 2024 SQL> SQL> SELECT G. FirstName AS FirstName, W G. LastName AS LastName, T. TotalFee AS TotalFee, CASE WHEN ROWNUM = 1 THEN 'A' WHEN ROWNUM = 2 THEN 'B' WHEN ROWNUM = 3 THEN 'C' END AS RankLetter 10 FROM GUEST G 11 INNER JOIN ( 12 SELECT 13 F. GUESTID AS GuestId, 14 SUM(F . FEECHARGED) AS TotalFee 15 FROM FEE F 16 WHERE F. FEETYPEID IN ( 17 SELECT FT. FEETYPEID 18 FROM FEE_TYPE FT 19 WHERE FT. FEETYPENAME IN ('Rate', 'Smoke Damage') 20 21 GROUP BY F . GUESTID 22 ORDER BY TotalFee DESC 23 ) T ON G. GuestID = T. GuestId 24 WHERE ROWNUM