Time for a coffee.sql | C# Online Compiler

Time for a coffee.sql by HarmenPelders

USE DoctorWho

SELECT AuthorName, Title, tblDoctor.DoctorName, tblEnemy.EnemyName, LEN(tblAuthor.AuthorName + Title + DoctorName + EnemyName) AS Length
   
FROM tblAuthor INNER JOIN
tblEpisode ON tblAuthor.AuthorId = tblEpisode.AuthorId
INNER JOIN tblDoctor ON tblEpisode.DoctorId = tblDoctor.DoctorId 
CROSS JOIN tblEnemy
WHERE LEN(tblAuthor.AuthorName + Title + DoctorName + EnemyName) < 40

​x
 
USE DoctorWho
​
SELECT AuthorName, Title, tblDoctor.DoctorName, tblEnemy.EnemyName, LEN(tblAuthor.AuthorName + Title + DoctorName + EnemyName) AS Length
   
FROM tblAuthor INNER JOIN
tblEpisode ON tblAuthor.AuthorId = tblEpisode.AuthorId
INNER JOIN tblDoctor ON tblEpisode.DoctorId = tblDoctor.DoctorId 
CROSS JOIN tblEnemy
WHERE LEN(tblAuthor.AuthorName + Title + DoctorName + EnemyName) < 40

0, 0, 0
1, 1, 1
1, 1, 1
2, 2, 2
3, 3, 3
5, 5, 5
8, 8, 8
13, 13, 13
21, 21, 21
34, 34, 34
55, 55, 55
89, 89, 89
144, 144, 144
233, 233, 233
377, 377, 377
610, 610, 610
987, 987, 987
1597, 1597, 1597
2584, 2584, 2584
4181, 4181, 4181

Cached Result
Last Run:	7:02:00 pm
Compile:	0.007s
Execute:	0.06s
Memory:	3.13Mb
CPU:	0.067s

View IL Code