ТБД первое задание

0

Please login or register to vote for this query.

(click on this box to dismiss)

Joomla

Q&A for Joomla! administrators, users, developers and designers

/*
select count(*) from Users 
where id not in(
  select distinct(OwnerUserId) from Posts 
  where year(CreationDate) = 2018 and PostTypeId = 1 and OwnerUserId is not null)
  */
  
  select count(*) FROM Users
  WHERE Users.Reputation > 100

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results