How do I display the ‘like komodo’ and ‘average(amount)’ commands at the same time
can you fix my code guys
here is my code
select *
FROM komodoshop
where name like ‘%komodo’ and AVG(amount) from name;
i want to use avg and like command at the same time in MySQL
New contributor
Obie Ganteng is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.