I'm glad to see you on my first web server (CW2003)
Free SQL query to MS SQL 6.5
Free SQL query
to MS SQL v6.5
Use pubs SELECT title, type, price, advance, pubdate FROM titles WHERE ytd_sales IS NOT NULL ORDER BY type DESC COMPUTE count(type), AVG(price), SUM(advance) BY type COMPUTE SUM(price), SUM(advance) SELECT title, type, price, advance FROM titles COMPUTE SUM(price), SUM(advance) use master exec sp_tables 's%' exec sp_databases Use pubs SELECT au_lname, au_fname FROM authors WHERE au_id IN ( SELECT au_id FROM titleauthor WHERE title_id IN ( SELECT title_id FROM titles WHERE type = 'popular_comp')) SELECT t1.type FROM titles t1 GROUP BY t1.type HAVING MAX(t1.advance) >= ALL( SELECT 2 * AVG(t2.advance) FROM titles t2 WHERE t1.type = t2.type) SELECT DISTINCT pub_name FROM publishers WHERE EXISTS ( SELECT * FROM titles WHERE pub_id = publishers.pub_id) SELECT distinct pub_name FROM publishers WHERE pub_id IN ( SELECT pub_id FROM titles WHERE type = 'business')
User Name
Password
Press to send
List of fields
in pubs database
authors authors.au_id authors.au_lname authors.au_fname authors.phone authors.address authors.city authors.state authors.zip authors.contract discounts discounts.discounttype discounts.stor_id discounts.lowqty discounts.highqty discounts.discount employee employee.emp_id employee.fname employee.minit employee.lname employee.job_id employee.job_lvl employee.pub_id employee.hire_date jobs jobs.job_id jobs.job_desc jobs.min_lvl jobs.max_lvl pub_info pub_info.pub_id pub_info.logo pub_info.pr_info publishers publishers.pub_id publishers.pub_name publishers.city publishers.state publishers.country roysched roysched.title_id roysched.lorange roysched.hirange roysched.royalty sales sales.stor_id sales.ord_num sales.ord_date sales.qty sales.payterms sales.title_id stores stores.stor_id stores.stor_name stores.stor_address stores.city stores.state stores.zip titleauthor titleauthor.au_id titleauthor.title_id titleauthor.au_ord titleauthor.royaltyper titles titles.title_id titles.title titles.type titles.pub_id titles.price titles.advance titles.royalty titles.ytd_sales titles.notes titles.pubdate titleview titleview.title titleview.au_ord titleview.au_lname titleview.price titleview.ytd_sales titleview.pub_id