用于计算列等于特定值的组中的行的SQL

I have a table with columns CMDNAME, TIME, and FAILED. There are a number of rows with the same CMDNAME value. The TIME column is just a timestamp for the transaction. The FAILED column is either "Y" or "N".I have a table with columns CMDNAME, TIME, and