How to add sorting from 10 to 20 in my line of code?

Question

SQL

In cell F6, write a formula and get all cells from sheet q that meet the following requirements:
- The date falls on 2018 - did this

=QUERY(RangeAll1, "select E,F,G,J where A contains 2018")

- ionization energy (eV) is from 10 to 20 eV - left to finish
- Column number (first line of sheet q) = 5 or 6 or 7 or 10 - made by hand

Answer 1

I didn’t find anything about the between selection in Google Sheets, but try
where A contains 2018 and X between 10 and 20
or
where A contains 2018 and X >=10 and X<=20
where X is a column, hell knows which one, it’s not clear from your question nothing at all.