- Server: PostgreSQL
216.158.72.53:5432
, version13.7 (Debian 13.7-0+deb11u1)
- Local time stamp:
2022-07-20T12:41:43.0051958+02:00
- Schema: public
- Table
public.addresses
- Table
public.alarm_alarm_contacts
/* | |
Task: get a set of movies where Zendaya played a role, | |
and for every such movie calculate the average review score, | |
and also retrieve the list of top 5 actors in the order of credits. | |
Here’s how such query can be written in EdgeQL: | |
select | |
Movie { | |
title, |
do | |
$$ | |
declare | |
_table_name text = 'md_temp'; | |
_md text = ' | |
| Command | Description | | |
| --- | --- | | |
| `git status` | List all *new or modified* files | | |
| `git diff` | Show file differences that **havent been** staged | | |
'; |
216.158.72.53:5432
, version 13.7 (Debian 13.7-0+deb11u1)
2022-07-20T12:41:43.0051958+02:00
public.addresses
public.alarm_alarm_contacts