Skip to content
This repository has been archived by the owner on Apr 14, 2024. It is now read-only.

Get all rental history by username #26

Open
wqyeo opened this issue Nov 22, 2023 · 0 comments
Open

Get all rental history by username #26

wqyeo opened this issue Nov 22, 2023 · 0 comments
Labels
good first issue Good for newcomers PostgreSQL: Function Related to a function in postgreSQL PostgreSQL schema: automobile PostgreSQL "automobile" schema

Comments

@wqyeo
Copy link
Member

wqyeo commented Nov 22, 2023

Title;

Create a function, where it takes in a username, and returns a row of all previously ended vehicle rentals related to the username, function should at least return the following information:

  • Registration Plate
  • Model Name
  • Manufacturer Name
  • Rental Start timestamp
  • Rental End timestamp

Feel free to make it return more information if you wish.

@wqyeo wqyeo added good first issue Good for newcomers PostgreSQL schema: automobile PostgreSQL "automobile" schema PostgreSQL: Function Related to a function in postgreSQL labels Nov 22, 2023
Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
good first issue Good for newcomers PostgreSQL: Function Related to a function in postgreSQL PostgreSQL schema: automobile PostgreSQL "automobile" schema
Projects
No open projects
Status: 🆕 New
Development

No branches or pull requests

1 participant