Question No. 35 / Question ID 974088
Marks: 4.00
Consider the following table, named as 'a', and answer the given query.
\begin{tabular}{|c|c|}
\hline Name & ID \\
\hline Amit & 1 \\
\hline Shweta & 2 \\
\hline Lavanya & 3 \\
\hline Rohit & 4 \\
\hline Isha & 5 \\
\hline
\end{tabular}
How many rows will be returned by the following query?
SELECT *
FROM a p, a q, a r
WHERE p.id $<$ q.id<br />
AND q.id > r.id;
1. 15
2. 30
3. 45
4. 50