SQL star schema queries

Question

I have created tables from star schema and write queries to analyze data. But my queries does not work please guide me! Thank you

https://code.sololearn.com/cAhXfEMj74TD/?ref=app

Answer 1

Hope this link helps you

https://code.sololearn.com/cQP69Q0W1xg7

Answer 2

Please give error information in your post, it helps to know where to look.

try first to build tables, query by query

- add semi colomn at the end of all queries
- delete comma at the end of tour create tables
- use this date format yyyy-MM-dd
- you miss the id in a reference Job_ID

- Remove the 'S=' in the select.
There is no Bids table, you search customers so select .... From DimCustomer1 maybe with right join on Job_fact ? I don't really understand What you looking for.

do step by step There is a lot of mistakes 😅