December 6, 2021 at 3:01 am
The dead giveaway that you're new to SQL is that you said these were complex.
What did you try? Post the SQL. People will help you if you do that. If you're asking for someone to do your homework for you, that's basically plagiarism. At least if you try it and get it wrong, you can explain your reasoning.
So post your attempt for each first. Unfortunately, the way you learn anything is by trying it, making mistakes, and figuring out why your answer isn't quite right, and then fixing it.
December 6, 2021 at 5:22 am
The patient's name is not present anywhere. That is, there's no way to know who patient "A", let alone to know what doctor(s) he/she saw.
SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".
Viewing 2 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply