I need a help to retrieve specific information from table. The table is named X and stores transactions. Each transaction id_trans corresponds to the id_customer. One id_customer might have 1 transaction logged, next id_customer might have 4 transactions logged and so on. The task is to display a table with two columns Number_of_trans and Number_of_id_customer. The output should display:
Any help would be very appreciated. Thank you in advance.