Write query (5.38) without the use of the views.
What will be an ideal response?
```
SELECT A.Dept
FROM (SELECT P.DeptId, AVG(P.Age) AS AvgAge
FROM Professor P
GROUP BY P.DeptId ) AS AvgDeptAge A
WHERE A.AvgAge = (SELECT MIN(A1.AvgAge)
FROM AvgDeptAge A1)
```
You might also like to view...
Case-Based Critical Thinking QuestionsCase 2 In his database of thousands of records, Suresh wants to standardize the format of certain fields. However, he does not want to store the formatting characters (e.g., parentheses, dashes, and slash characters). He decides to consult Sheila because she has extensive experience with input masks. Suresh wants to make letter entries optional in a license plate number field, as not all license plates have letters. What is the input mask character Sheila tells him to use?
A. L B. ? C. P D. !
What is the output of the function call strange (6) given the following definition?
void strange (int n) { if (n > 1) { cout << n + 1 << “ “ << endl; strange (n-2); cout << n-1 << “ “ << endl; } }
JavaScript supports the use of symbols known as operators to compare or change the values of multiple objects or properties._________________________
Answer the following statement true (T) or false (F)
To uninstall a Windows 8 app, you would _____ the app's tile on the Start screen or Apps screen.
A. left-click B. double-click C. right-click D. press Ctrl+R on