-- Database schema
| authors : au_id [ TEXT ] primary_key , au_lname [ TEXT ] , au_fname [ TEXT ] , phone [ TEXT ] , address [ TEXT ] , city [ TEXT ] , state [ TEXT ] , zip [ TEXT ] , contract [ TEXT ] | jobs : job_id [ INTEGER ] primary_key , job_desc [ TEXT ] , min_lvl [ INTEGER ] , max_lvl [ INTEGER ] | publishers : pub_id [ TEXT ] primary_key , pub_name [ TEXT ] , city [ TEXT ] , state [ TEXT ] , country [ TEXT ] | employee : emp_id [ TEXT ] primary_key , fname [ TEXT ] , minit [ TEXT ] , lname [ TEXT ] , job_id [ INTEGER ] employee.job_id = jobs.job_id , job_lvl [ INTEGER ] , pub_id [ TEXT ] employee.pub_id = publishers.pub_id , hire_date [ DATETIME ] | pub_info : pub_id [ TEXT ] primary_key pub_info.pub_id = publishers.pub_id , logo [ BLOB ] , pr_info [ TEXT ] | stores : stor_id [ TEXT ] primary_key , stor_name [ TEXT ] , stor_address [ TEXT ] , city [ TEXT ] , state [ TEXT ] , zip [ TEXT ] | discounts : discounttype [ TEXT ] , stor_id [ TEXT ] discounts.stor_id = stores.stor_id , lowqty [ INTEGER ] , highqty [ INTEGER ] , discount [ REAL ] | titles : title_id [ TEXT ] primary_key , title [ TEXT ] , type [ TEXT ] , pub_id [ TEXT ] titles.pub_id = publishers.pub_id , price [ REAL ] , advance [ REAL ] , royalty [ INTEGER ] , ytd_sales [ INTEGER ] , notes [ TEXT ] , pubdate [ DATETIME ] | roysched : title_id [ TEXT ] roysched.title_id = titles.title_id , lorange [ INTEGER ] , hirange [ INTEGER ] , royalty [ INTEGER ] | sales : stor_id [ TEXT ] sales.stor_id = stores.stor_id , ord_num [ TEXT ] , ord_date [ DATETIME ] , qty [ INTEGER ] , payterms [ TEXT ] , title_id [ TEXT ] sales.title_id = titles.title_id | titleauthor : au_id [ TEXT ] titleauthor.au_id = authors.au_id , title_id [ TEXT ] titleauthor.title_id = titles.title_id , au_ord [ INTEGER ] , royaltyper [ INTEGER ] |
-- -- In 1994 which title had less order quanty than the average order quantity? Find the title name, type and price.

SELECT DISTINCT T1.title, T1.type, T1.price FROM titles AS T1 INNER JOIN sales AS T2 ON T1.title_id = T2.title_id WHERE T2.ord_date LIKE '1994%' AND T2.Qty < ( SELECT CAST(SUM(T4.qty) AS REAL) / COUNT(T3.title_id) FROM titles AS T3 INNER JOIN sales AS T4 ON T3.title_id = T4.title_id );