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