Hi, On the Lecture wk 10, Slide 28-29 mentions the following: (a) If column in view is based on an aggregate function: • Column may appear only in SELECT and ORDER BY clauses of queries that access view. • Column may not be used in WHERE nor be an argument to an aggregate function in any query based on view. And, it also mentions that "This is ISO. This works in SQLite!!' Could someone please clarify if we can use the restriction (mentioned in (a)) in SQLite? Thanks.

Hi, The examples that you have mentioned are going to work in sqlite (see the code below). However, this is not going to work with other dilects of SQL. You can use it in sqlite if you want to. In the exam, if you have written a query that either works in sqlite or is ISO, it will be considered correct. Cheers