Answer the question
In order to leave comments, you need to log in
How in this case to get access to the table?
Hello! There is the following SQL
request:
SELECT model, p FROM
(
SELECT model, max(price) AS p
FROM laptop
GROUP BY model
UNION
SELECT model, max(price)
FROM pc
GROUP BY model
UNION
SELECT model, max(price)
FROM printer
GROUP BY model
) AS matherial
model
with the maximum price ... I tried to get it using... AS matherial WHERE p IN (SELECT max(p) FROM matherial)
But apparently, the skuel interpreter does not see this matherial table at the WHERE execution stage, tell me pliz how can I display the model, by the way, the MODEL, without the price
Answer the question
In order to leave comments, you need to log in
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question