create table measurement (
  measurement_date date,
  temperature number,
  humidity number);

create table temperature_description (
  value_from number,
  value_to number,
  description varchar2(100));

create table humidity_description (
  value_from number,
  value_to number,
  description varchar2(100));

insert into measurement values (sysdate, 10, 50);
insert into measurement values (sysdate, 20, 99);
insert into measurement values (sysdate, 30, 35);
insert into temperature_description values (0, 15, 'Холодно');
insert into temperature_description values (15, 25, 'Нормально');
insert into temperature_description values (25, 100, 'Жарко');
insert into humidity_description values (0, 40, 'Сухо');
insert into humidity_description values (40, 70, 'Нормально');
insert into humidity_description values (70, 100, 'Влажно');

select m.measurement_date, m.temperature, td.description, m.humidity, hd.description
  from measurement m
       join temperature_description td on td.value_from < m.temperature
                                      and td.value_to > m.temperature
       join humidity_description    hd on hd.value_from < m.humidity
                                      and hd.value_to > m.humidity