What will the creation of an sql query look like based on this example?

Question

MySQL

Hello, help me compose a sql query from the following example, I have not done such things before, if possible, then with an explanation of each item, so that I understand how to do it correctly.
Example:
There is a "Quick Search" button on a web page that selects from the CHAR table in the database all characters above level 45 (level column), dwarf race (race column) and displays the result on the page.

Answer 1

fetch -> SELECT
all records -> *
from table named "CHAR" -> FROM CHAR
if -> WHERE
column "level" is greater than 45 -> level > 45
and -> AND
column "race" equals "dwarf" -> race="dwarf"

SELECT * FROM CHAR WHERE level > 45 AND race="dwarf"