An inline view replaces a table in the from clause of your query. In this query, "select * from bricks" is an inline view
#Oracle
#Inline_views

You use inline views to calculate an intermediate result set. For example, you can count the number of bricks you have of each colour using this particular code.
#Oracle
#Inline_views_2

You can then join the result of this to the colours table. This allows you to find out which colours you have fewer bricks of than the minimum needed defined in colours.
#Oracle
#Inline_views_3