You have chosen to sponsor your bid up to a maximum amount of .
I need 5 SQL queries that simulate the behaviour of a database graph (for example Neo4j).
I have a table named "US" (id, number, description) and another table named "RELATIONSHIPS" (us1, us2, type) that describes the relationships between two elements from the US table, and what type of relationship.
Example queries i have to obtain:
- Find the shortest path between two US
- Find all US and relative paths that have a specific characteristic (described in another table named "CLASS").