view sql

Views that i mean is we can use views method without creat views.

For example:
select product_name,qty from (
    select 'book notes'product_name,(4)qty union
    select 'pencil',(15) union
    select 'book notes',(3) union
    select 'pencil',(10)
)view1 where product_name='pencil' order by product_name

#Results:
product_name    qty
pencil          15
pencil          10