I have a reservation table that has ID, ORIGIN (site, app or null) I want to know the percentage of reservations made by the app and the site,
select count(id) from booking where origin = 'app' / select count(id) from booking where origin is not null * 100;
How do I make this calculation in MySQL?