Does anyone know why this query is returning this error?

select tranId, trandate
from salesorder
where trandate = 10/14/2022

Search error occurred: Record 'salesorder' was not found.

I tried using "salesord" instead of "salesorder" but when I do that, I get this error:

Invalid search type: salesord

Sales orders are actually stored in the Transaction table, as Type "SalesOrd." So you would do something like this:

SELECT
	TranID,
	TranDate
FROM 
	Transaction 
WHERE 
	( Type = 'SalesOrd' )
	AND ( TranDate = TO_DATE( '2022-10-14', 'YYYY-MM-DD' ) )

Thanks @tdietrich that is helpful. What would you say are the best resources to learn SuiteQL? I just started writing queries a few weeks ago, so I'm still at a basic level. Perhaps you can tell I'm doing my queries via the tool you built.