I'm trying to work this out in SQLite3, and been failing for hours now!
Imagine I have this table (named products), for example purposes:
Company | Product | Price (£)
--------|---------|----------
Apple | iPhone | 349
Samsung | Galaxy | 300
Sony | PS4 | 229
Sony | Xperia | 249
What query would I use, to show how many products there are by each company? Presenting similar results to the following:
Company | ???
--------|---------
Apple | 1
Samsung | 1
Sony | 2
Any help would be much appreciated, as it's stressing me out!
Thanks!
Aucun commentaire:
Enregistrer un commentaire