Query for the clients and some people

Id=3 does not mean the third

@AndSoWeCode was waiting for this, auto increment starts from 1,2,3...

@const nowhere is it specified that it's auto increment, or the order that fingers are inserted.

@AndSoWeCode that's why this is a meme/joke, not gonna create complete table for this 😅

Fingers start at zero.

*2

select cast(round(cast(count(finger) as float)/2)+0.5 as int) as ‘fuck id’ from hand

Somebody has to be the person who points out (with a finger?) that the thumb, while a digit of the hand, is not a finger.

id starts from 0. So...

Never have I heard sql table id starts from 0

select finger, max(finger_length)
from finger;

Bug report: Doesn't work for people born with four fingers on one hand.

@Benedikt see my previous comment.

@tizo That's not correct. Even if the thumb only has two phalanxes, it is nevertheless one of the five fingers of the hand.

@Benedikt google it. From Oxford dictionary: ‘Digit’ is the technical term which covers fingers, thumbs, and toes in humans, and similar appendages in some animals. The thumb is the short, thick first digit of the human hand. The other four digits are our fingers.

I will concede though that Oxford dictionary conceded that the connotation of finger includes the thumb but the denotation does not.

Let me settle this.

SELECT `finger`
FROM `hand`
WHERE `hand`.`fingerName`
IS LIKE '%dirty%'
LIMIT 1;

@tizo There seems to be multiple definitions. So it is not wrong to call the thumb a finger.
In fact, most English sources I found called it a finger. And in German sources (this definition should be language independend) it's always called a finger.