keep getting a ambiguous error for this question below question- Join the payment_info and payments table together based on PK/FK. Display the count of records for each payment type. use first; select payment_type, count(payment_info_id) from payment_info join payments where payments.payment_info_id = payment_info.payment_info_id Tables and colums are customer_product - id , ordered_amount , customer_id , product_id ,payment_id customers - customer_id , first_name , last_name , email , phoneNo , shipping_detail_id invoice - invoice_id , invoice_no , amount , invoice_date payment_info - payment_info_id , payment_type payments - payment_id , payment_info_id , invoice_id products - product_id , product_name , details , category , quantity shipping_details - shipping_detail_id , address , city , province
keep getting a ambiguous error for this question below
question- Join the payment_info and payments table together based on PK/FK. Display the count of records for each payment type.
use first;
select payment_type, count(payment_info_id) from payment_info
join payments
where payments.payment_info_id = payment_info.payment_info_id
Tables and colums are
customer_product - id , ordered_amount , customer_id , product_id ,payment_id
customers - customer_id , first_name , last_name , email , phoneNo , shipping_detail_id
invoice - invoice_id , invoice_no , amount , invoice_date
payment_info - payment_info_id , payment_type
payments - payment_id , payment_info_id , invoice_id
products - product_id , product_name , details , category , quantity
shipping_details - shipping_detail_id , address , city , province
thanks
Step by step
Solved in 2 steps
