In 1994 which title had less order quanty than the average order quantity? Find the title name, type and price.
orders in 1994 refers to YEAR(ord_date) = 1994; order quantity refers to number of order expressed by ord_num; average order quantity = DIVIDE(SUM(ord_num), COUNT(title_id))
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 )
database name:db_id book_publishing_company
authors table authors Cols: author id dtype text, author last name dtype text, author first name dtype text, phone dtype text, address dtype text, city dtype text, state dtype text, zip dtype text, contract dtype text, 
jobs table jobs Cols: job id dtype integer, job description dtype text, min level dtype integer, max level dtype integer, 
publishers table publishers Cols: publisher id dtype text, publisher name dtype text, city dtype text, state dtype text, country dtype text, 
employee table employee Cols: employee id dtype text, first name dtype text, minit dtype text, last name dtype text, job id dtype integer, job level dtype integer, publisher id dtype text, hire_date dtype datetime, 
pub_info table pub_info Cols: publication id dtype text, logo dtype blob, publisher's information dtype text, 
stores table stores Cols: store id dtype text, store name dtype text, store address dtype text, city dtype text, state dtype text, zip dtype text, 
discounts table discounts Cols: discount type dtype text, store id dtype text, low quantity dtype integer, high quantity dtype integer, discount dtype real, 
titles table titles Cols: title id dtype text, title dtype text, type dtype text, publisher id dtype text, price dtype real, advance dtype real, royalty dtype integer, year to date sales dtype integer, notes dtype text, publication date dtype datetime, 
roysched table roysched Cols: title_id dtype text, low range dtype integer, high range dtype integer, royalty dtype integer, 
sales table sales Cols: store id dtype text, order number dtype text, order date dtype datetime, quantity dtype integer, payterms dtype text, title id dtype text, 
titleauthor table titleauthor Cols: author id dtype text, title id dtype text, author ordering dtype integer, royaltyper dtype integer, 
