The SELECT SQL keyword can be used in a query to tell the server what to retrieve from the database. It may be followed by * (retrieves every column from the table), a column name ('username' for exemple), or by a function (COUNT(username) for exemple).
Here, the SELECT keyword tells the server to fetch all data from the 'users' table.