Question

stores 8 stor_id stor_name stor_address city state zip 0 00 discounts employee emp_id fname discounttype stor_id pub_info 8 pub_id logo pr_info minit Iname lowaty highaty discount job_id job_M pub id hire_date sales 7 stor_id * ord_num ord_date qty payterms title_id publishers 8 pub_id pub_name titleauthor au_id titleid au_ord royaltyper jobs 8 job_id job_desc min Ivi city state max v country titles title_id authors au id title au_Iname type pub_id au fname roysched title_id phone price address lorange hirange advance city royalty state royalty ytd_sales zip notes pubdate contract

Answer 1

Dear Student ,

As per the requirement submitted above , kindly find the below solution.

Question :

SQL Query :

select pub_name from publishers ,titles where publishers.pub_id=titles.pub_id and royalty > 10;

Explanation :

• Above sql query will join two tables publishers and titles based on pub_id and
• will return the publisher name where royalty is greater than 10

NOTE : PLEASE FEEL FREE TO PROVIDE FEEDBACK ABOUT THE SOLUTION.