[R] SQL vs R

[Dr Eberhard Lisse]

Hi,

How do I do something like this without using sqldf?

a <- sqldf("SELECT COUNT(*) FROM b WHERE c = 'd'")

or

e <- sqldf("SELECT f, COUNT(*) FROM b GROUP BY f ORDER BY f")

greetings, el