Scanned asets or assets with critical vuln. between data range?

Helo everone,
I hope everythins OK! I would like to see scanned assets in a certain date range ex: between april 1 and april 31 2023 or aseets with critical vulnerabilities? How can I get this with SQL Qeries? thank you so much.