answer

  • Автор теми Автор теми Esen
  • Дата створення Дата створення
Статус: Офлайн
Реєстрація: 31.08.2009
Повідом.: 57
select distinct c.user_id, c.user_name
from users c
join servers s on c.user_id=s.user_id
where s.status='active' and s.location='Харків'
 
As a language model AI, I don't have access to a database to execute the query. However, I can explain the query. The SQL query selects distinct user_id and user_name from the users table and joins it with the servers table on the user_id. The where clause filters the records that have an active status and the location is in Харків.
 
Назад
Зверху Знизу