М
Крч @алек
Size: a a a
2020 October 30
K
Я ему пишу...
z
Я ему пишу...
Трубы чистите?
М
@YellowYoba препод показала код
М
SELECT A.name as passengerName1, B.name as passengerName2, COUNT(*) as count
FROM
(SELECT DISTINCT name, passenger, trip FROM Pass_in_trip INNER JOIN Passenger ON Pass_in_trip.passenger=Passenger.id) as A
INNER JOIN
(SELECT DISTINCT name, passenger, trip FROM Pass_in_trip INNER JOIN Passenger ON Pass_in_trip.passenger=Passenger.id) as B
on A.trip = B.trip and A.passenger < B.passenger
GROUP BY passengerName1, passengerName2
HAVING count >= 2
FROM
(SELECT DISTINCT name, passenger, trip FROM Pass_in_trip INNER JOIN Passenger ON Pass_in_trip.passenger=Passenger.id) as A
INNER JOIN
(SELECT DISTINCT name, passenger, trip FROM Pass_in_trip INNER JOIN Passenger ON Pass_in_trip.passenger=Passenger.id) as B
on A.trip = B.trip and A.passenger < B.passenger
GROUP BY passengerName1, passengerName2
HAVING count >= 2
K
SELECT A.name as passengerName1, B.name as passengerName2, COUNT(*) as count
FROM
(SELECT DISTINCT name, passenger, trip FROM Pass_in_trip INNER JOIN Passenger ON Pass_in_trip.passenger=Passenger.id) as A
INNER JOIN
(SELECT DISTINCT name, passenger, trip FROM Pass_in_trip INNER JOIN Passenger ON Pass_in_trip.passenger=Passenger.id) as B
on A.trip = B.trip and A.passenger < B.passenger
GROUP BY passengerName1, passengerName2
HAVING count >= 2
FROM
(SELECT DISTINCT name, passenger, trip FROM Pass_in_trip INNER JOIN Passenger ON Pass_in_trip.passenger=Passenger.id) as A
INNER JOIN
(SELECT DISTINCT name, passenger, trip FROM Pass_in_trip INNER JOIN Passenger ON Pass_in_trip.passenger=Passenger.id) as B
on A.trip = B.trip and A.passenger < B.passenger
GROUP BY passengerName1, passengerName2
HAVING count >= 2
так это... сейчас ормки и носкулы в моде
K
🤮А
@YellowYoba ты понял как ту хуйню делать?
я пока работкаю
🤮А
SELECT A.name as passengerName1, B.name as passengerName2, COUNT(*) as count
FROM
(SELECT DISTINCT name, passenger, trip FROM Pass_in_trip INNER JOIN Passenger ON Pass_in_trip.passenger=Passenger.id) as A
INNER JOIN
(SELECT DISTINCT name, passenger, trip FROM Pass_in_trip INNER JOIN Passenger ON Pass_in_trip.passenger=Passenger.id) as B
on A.trip = B.trip and A.passenger < B.passenger
GROUP BY passengerName1, passengerName2
HAVING count >= 2
FROM
(SELECT DISTINCT name, passenger, trip FROM Pass_in_trip INNER JOIN Passenger ON Pass_in_trip.passenger=Passenger.id) as A
INNER JOIN
(SELECT DISTINCT name, passenger, trip FROM Pass_in_trip INNER JOIN Passenger ON Pass_in_trip.passenger=Passenger.id) as B
on A.trip = B.trip and A.passenger < B.passenger
GROUP BY passengerName1, passengerName2
HAVING count >= 2
издец
🤮А
а может он нахуй пойдёт с двумя дистинктами?
N
так это... сейчас ормки и носкулы в моде
Тут скозали что это не работает
K
Тут скозали что это не работает
что не работает
N
что не работает
Ормы не работают
М
издец
Да
М
вообще какая то хуета
K
Ормы не работают
тык заставить над
🤮А
вообще какая то хуета
именно
🤮А
думаю, можно красившее сделать
N
А мне похуй у меня Mongo с ОРМ
K
А мне похуй у меня Mongo с ОРМ
хваахвхахвах