hi trying to get a job where i have to write sql queries. i have writen some queries but i have to do a project. that way i can show the project to other people. any ideas of a sql projects?

Try a quiz style application, where you can insert multiple choice data in various formats. That way you can also perform statistics on the results that can be shown on a dashboard page. You can use queries, views, stored procedures and triggers when building it. Don't forget normalization, indexes and foreign keys.