question archive Write a SELECT query #1 to read the prime key value of the 'oil' base record into a user defined variable
Write a SELECT query #1 to read the prime key value of the 'oil' base record into a user defined variable
Subject:Computer SciencePrice: Bought3
Write a SELECT query #1 to read the prime key value of the 'oil' base record into a user defined variable. Use that user defined variable in a subquery within SELECT query #2 that produces a result grid containing paintName, tintName, and tintValue. Use the subquery to filter out all paint records that are not related to an oil base. Sort the result grid of query #2 by tintValue. Reduce the result grid of query #2 to only the third, fourth, and fifth highest values of tintValue.
