By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
11 rows affected
| Name | Trial | Start | End | flag |
|---|---|---|---|---|
| Emily | A | Oak St | Oak St | No |
| Emily | B | Oak St | Elm Rd | No |
| Frank | A | Main Ave | Main Ave | Yes |
| Frank | B | Main Ave | Main Ave | Yes |
| Frank | C | Main Ave | Main Ave | Yes |
| James | A | Deer Rd | Deer Rd | Yes |
| James | B | Deer Rd | Deer Rd | Yes |
| Jeff | A | Main Ave | Main Ave | No |
| Jeff | B | Oak St | Oak St | No |
| Julie | A | Ranch St | Ranch St | No |
| Julie | B | Ranch St | North Blvd | No |