Where I'm From I'm not from a country of fortune and fame, I'm just from a group that thinks it's a game. I'm not from a place of emotional flow, But more from a place where nothing will show. I am from the seaside, I'm waiting for tide, The amount of their feelings that people will hide. I am from a country with a colorful past, "How long?" they said, "How long will it last?" Dark clouds sent by gods as they form in the sky, Like millions of people on the streets walking by. Now, imagine that people would become extinct, Their knowledge, their data all lost in a blink. But maybe our lives are not what they seem, Maybe, just maybe, it's all just a dream.
Raido Hiiuväin 11b ,,Where there is love there is hapiness" I think that love is the key to happiness. Very often people think that all kind of material things make them happy, but usually this is wrong. People seem to realise that only then, when they lose a friend or close person. After these situations they become to realise that family, friends and good relationships are the most important. Where there is love there is happiness I totally agree. I think that love can make people feel happy. Money, fancy clothes and sportcars do not make anyone happy without warm and close people around. Usually rich people are not happy at all, because the don't have reliable friends and very often people spend time with rich people because they have money and luxorios things. Poor people seem to have reliable friends, they have support of their friends and do not have to think about
Tartu Ülikool Sotsiaal- ja haridusteaduskond Haridusteadus (humanitaarained) WHERE US AND RUSSIAN INTERESTS OVERLAP Referaat Juhendaja: Eero Medijainen Tartu 2010 Venemaad nähakse kui läbikukkunud demokraatiaga riiki, kes toetub oma gaasi- ja naftavarudele ning üritab kõige ja kõigi üle kontrolli hoida või saavutada. Üldiselt räägitakse Venemaast negatiivses võtmes
For example Tallinn, London, New York or Paris. To start with, I would like to live in a big city because of its advantages. Big cities usually have more opportunities to spend your day and night. There are cinemas, coffee shops, theatres, shopping centres, libraries and night clubs. Although you need money to attend different exhibitions and shows big city also offers you free activities. Secondly, there are lots of banks, company offices and factories where people can work. That is the second reason I think big city life is better than a life in a small village. Last but not least, people usually think that they would not like to live in a big city because there are too many people there and they would feel suffocated. But there are areas outside the centre of the town where people live. Big cities also have good roads and big parking lots. In conclusion, I would like to say that although big city has its disadvantages I am more
'Destroying A ngel' (Amanita vir osa) and other poison ous mushrooms in Estonia Ursula 11. kl Destroying Angel 0 Commonly referred to as the Destroying Angel, Amanita virosa is a deadly poisonous fungus. The Destroying Angel is more plentiful in mountainous areas and grow in or near the edges of woodlands. They can also be found on lawns or grassy meadows near trees or shrubs. 0 Destroying Angels usually appear in July, August and September. Immature specimens of A. virosa resemble several edible species commonly consumed by humans, increasing the risk of accidental poisoning. Description of Destroying Angel 0 Caps of the Destroying Angel are 5 to 10cm in diameter, pure white, and without any marginal striations. The cap is initially egg- shaped or occasionally almost flat. Amanita ...
docstxt/1313515123129285.txt
Homework I live in Muuga, it's about 13km from the city center. Muuga belongs to city Maardu, it is like a little village between Maardu and Pirita and Lasnamäe. Here in Muuga, there are many little cottages and detached houses with yards. It is a very quiet and calm village. We have here only 3 food-shops, two really small ones and a bigger one ,,Maxima". Here is also being built a kindergarden. Near here we have a little staying place, something like a motel. We have a bus from the center, it takes nearly 35 minutes to get from the center to Muuga. Bus comes every 17-25 minutes, so it is quite comfortable. A lot of place to walk, go jogging and ride a bike. I'm happy that i live near the bus stop, it's very good for me, but however sometimes I may miss the bus. I can walk here in my yard only in a robe and nobody will tell me anything, that's why i like Muuga and also for its tranquilness. But i d...
nature What is nature? Nature, in broadest sense, is material world- all the universum. In smaller sense, nature is part of world, which is not influenced by humen activity. Where come from word nature? The word nature is derived from the Latin word natura, or "essential qualities, innate disposition", and in ancient times, literally meant "birth". Natura was a Latin translation of the Greek word physis which originally related to the intrinsic characteristics that plants, animals, and other features of the world develop of their own accord. Most Beautiful Places Of The World We quite often see and read about manmade wonders of the world but have
THE MILLENIUM FOOTBRIDGE What, where & when? • For pedestrians • located between Southward Bridge (downstream) and Black friars Railway Bridge (upstream) • Connects St.Paul’s Catherdal and Tate Modern • owned and maintained by the Bridge House Estates • Construction of the bridge began in 1998 • opening on 10 June 2000. Closing, unexpected & not safety? • Londoners nicknamed Wobbly Bridge • crossed by 90,000 people, with up to 2,000 on the bridge at any one time. • a charity walk on behalf of Save the Children • Swaying motion • Closed after two days of limited access. • Reopened after two years when the bridge was entirely safe. In 2002. Particulars : • Design : Suspension bridge • Total length: 370 meters • Width: 4 meters • Longest span:144 meters • 5,000 people on the bridge at one time • on 28 April 1999 by Monberg Thorsen and Sir Robert McAlpine • cost of £18.2 million A little bit mo...
GHOST MOUNTAINEER Must alpinist RaidoM Ghost mountaineer Ghost mountaineer was made in 2015. This movie is filmed in Buryatia, where the events took place. This movie's title is based on a legend who is dead mountaineer, his death circumstances remained unclear and his soul because of that can't ever get peace. Hallucinatory ghost mountaineer seeing in the mountains brought disaster. Ghost mountaineers summary The film takes place in 1989. Six Estonian students are going to climb to a mountain in Buryatia. One night Eero is telling a story about an mountaineer, who died on mountain
If you could visit three places anywhere in the world, where would you go and what would you do there? If I could visit three places in the world, I think I'd choose civilized places in Europe, America and Australia rather than exotic locations. I've been to abroad and I like travelling. Firstly I would like to go to America. If I had to choose, I'd probably go to San Francisco. There are a lot of sights: Golden Gate Bridge, the Conservatory of Flowers in Golden Gate Park, Alcatraz, City Hall, Chinatown, Museum of
1851, later communist, started new life many times, black shining eyes, really thin and old. • Boswell Johnson – really famous author, the ancestor of Joe. • Napoleon Bonaparte – a relative of French Joe, lietutenant of artillery • Russians + Prussians – Joe fougth against them in French army • Hospital Nurse PLACES: • Thursday Island in Torres Straits – where he went + Joe's final destination • Sydney – where he came from • Shika Maru – last stop before Thursday Island • New Caledonia – prison, where Joe was. • Melbourne – where he fleed the boat • New Guinea – where he went to live after Melbourne STORY: Thursday Island is the last place God ever made. People in Sydney told me not to go, because there was nothing to see and I should get my throat cut. He had come up from Sydney in a Japanese tramp.
You are going to write your own magazine article on what your life will be like in ten years' time. 1.what are you doing now? 2.how do you see yourself changing in the next few years? 3.what will you be doind 4.what will you have done? 5.where will you be living 6.will you have got married? 7.will you have travelled a lot? Everybody has their dreams and ideas, how they want they're life to be. Right now I am a school student. I'm dancing, playing guitar and just hang out with my friends. I'm in the tenth grade of high-school, so I have only two years to decide what I want to do after graduating. But I think I don't really want to study anything more, I just want to see what the life has for me
It was also one of the most important trees in the history of European warfare, as its wood was used exclusively for the making of the longbows, spears and dagger handles. In the past they were used as landmarks, because of their size and longevity, and their dark branches would make them stand out in the landscape. It is excellent for furniture making, interior, fences, gates, chairs, doors, tables, and rustic furniture. Where the Yew Grows It is also possible to find small trees growing near bigger trees, which transplant well. They prefer a moist, fertile, sandy loam soil, but will grow well in most soils except water-logged ground or sticky wet clay. They also grow well on chalk. They resist pollution and can flourish in the shade of taller trees. Yew trees are often found lining cemeteries and churchyards Ancient yews Yews are slow-growing and long-lived, and
ACETYLCHOLINE – A neurotransmitter in both the brain and peripheral nervous system* (PNS). In the brain it helps regulate memory, whilst it controls the actions of skeletal and smooth muscle within the PNS. ACTION POTENTIAL – An electrical phenomenon which occurs when a neurone is activated and temporarily reverses the electrical state of its interior membrane from negative to positive. An electrical charge travels along the axon to the neurone’s ending (terminal) where it triggers the release of a neurotransmitter* and then disappears. ADRENALINE (U.S. - Epinephrine) – A hormone released by the adrenal medulla* and a neurotransmitter acting at the level of the autonomic nervous system and the brain. ADRENAL CORTEX – The outer layer of the adrenal, a small endocrine gland located near the kidney. It produces and secretes several hormones* (corticosteroids) e.g. cortisol. It is implicated in stress response.
Mr. Püüa 4 November 2011 21 Park Street Pärnu 80010 Estonia Dear Mr Püüa I am waiting in a reply to your advertisement in Pärnu Postimees to apply for the position of football coach. I have been working in two different places. One was my own founded internet payment service, which is doing actually pretty good and the other place is at Karhu Kauhajoki, where I am the main coach for boys who are aged between 14 to 18. Also I went to body culture school in Denmark, which I graduated Cum Laude with GPA 4,9 out of 5,0. I have also finished Ahtme high school with gold medal, it is the only school in Estonia which bases mainly on football. I am a native estonian speaker and I can also speak and write perfectly in english, finnish and russian. In english and finnish I have reached upper conversation level and in russian advanced conversation level.
My ideal house I would like to live in a place where there are some mountains with snow on top of them and a sea nearby because i like beaches and mountains. My house would be in the middle of them, so i could see the sea from one side and the mountains from the other side of the house. The house would have two floors and a basement because that's all i need. On the first floor, there would be the living room with a big tv and some antique furniture, the kitchen, also with antique style oven and etc. A bathroom with a
Film review "Scent of a Woman" 1992 by Martin Brest Scent of a Woman is the story of Frank Slade, a blind, retired army colonel who hires Charlie Simms, a poor college student on the verge of expulsion, to take care of him over Thanksgiving weekend. At the beginning of the weekend, Frank takes Charlie to New York, where he reveals to the student that he intends to visit his family, have a few terrific meals, sleep with a beautiful woman and, finally, commit suicide. Over the weekend, as they learn about life through their series of adventures, they start trusting eachother. Two absolute favourite scenes: The first is in the New York ballroom where the blind Lt. Colonel teaches a lady to dance the tango. It is so smooth and dramatic that even a couch potato is tempted to dance along
NIMETUS VARCHAR2(40) SQL> COLUMN eesnimi FORMAT A12; SQL> COLUMN perenimi FORMAT A12; SQL> COLUMN failinimi FORMAT A8; SQL> --Koostage tabelite lepikult.yliopilased,lepikult.koduylesanded, lepikult.oppeained abil kursuse “Oracle” kodutööde andmed SQL> SELECT y.eesnimi, y.perenimi, k.kuupaev, k.too_nr AS ulesande_nr, k.punktid AS punkte, k.failinimi FROM lepikult.yliopilased y, lepikult.koduylesanded k WHERE y.id = k.yliopilase_id; EESNIMI PERENIMI KUUPAEV ULESANDE_NR PUNKTE FAILINIM ------------ ------------ --------------- ----------- ---------- -------- Katrin Kask 11-JUN-03 1 5 t1.txt Katrin Kask 12-JUN-03 1 7 t2.txt Katrin Kask 17-JUN-03 1 8 t3.txt Kairi M„nd 01-JUN-03 1 10 t7.txt
FROM YouTube: A History Of Scotland - Episode 1 - The Last Of The Free (1/6) 1. Why is the early Scottish history often mythologised? Early Scottish history is often mythologised because its earliest records are almost always written by others (for example Tacitus). 2. Directly and indirectly, what did the Hadrian Wall represent? It represented directly the border of the Roman colonies in Britain and indirectly the ‘’end of the world’’, where true (Roman) civilization ended and savagery began. A History Of Scotland - Episode 1 - The Last Of The Free (2/6) 1. Why shouldn`t we call the Pictish society barbarian? They were affluent, had a good diet, were very organized, probably communicated with people far away 2. What were the differences between the Gaels and the Picts? They converted to Christianity before the Picts 3
1) Describe the photo!! · Describe what you can see and what is happening in the photos. · Say where it's happening: ie on the left/right, at the bottom/top, in the middle,behind, in front · Use Present Continuous. What are they doing? · What clothes are they wearing? · What's the weather like? · Are they inside or outside? · Use adjectives. Do they look happy, sad, angry bored, tired? · How does the photo make you feel? · Would you like to be there? Why/Why not? 2)Comparing and contrasting photos!! · Similarities; all, most, some, both.
Roman city, the street system(paved roads), benefits for the poor, public heated baths, art, architecture. They also influenced the language (pound, butter, cheese, wine, candle). 9. Which areas of life is English used in? technology, science, politics, tourism, aviation 10. Which languages influenced the Old English (until the 10th century) most?Anglo-Saxon, Celtic(the Celts), Scandinavian languages (Norse and Danish), Latin (the Romans) 11. Where do British people live? British Isles 12. Describe Ireland.- N I is famous for the Giant's causeway. Anthem God save the queen, 13. What is the approximate population of the 4 constituent countries? 62 million. England- 51,4 million, Scotland- 5,1 , Wales 2,9 m , Northern Ireland 1,8 million. 14. How did the Anglo-Saxons influence Britain? Language, first settlers on British Isles 15. Name some countries where English is used as the first language
USINESS PEOPLE ROFILE (Session 2): of Description Describe convincingly that you are passionately committed to your new My Business Prepare aand business cashhave flowthe projection based realism to makeoninevitable lowered expectations hard choices.and show how and where you would reduce costs to maintain liquidity. Targeted Market and Customers Prepare a cash flow projection based on lowered expectations and show how and where you would reduce costs to maintain liquidity. THE PEOPLE Work Experience Related to My Intended Business (Session 2): Describe your work experience in the business you plan to start including a list of your skills and knowledge, which will be required in your business. Growth Trends In This Business
--Taavet Tamm(a72028) --ylesanne 4. --1. Leida klubi Laudnikud liikmete nimekiri (eesnimi ja perenimi) tähestiku järjekorras. SELECT eesnimi, perenimi FROM isik, klubi WHERE klubi.nimi = 'Laudnikud' ORDER BY perenimi asc; --2. Leida klubi Laudnikud liikmete arv. SELECT COUNT(*) AS "Klubi Laudnikud liikmete arv" FROM isik WHERE klubi = '51'; --Leida V-tähega algavate klubide M-tähega algavate eesnimedega isikute perekonnanimed. SELECT distinct perenimi FROM isik, klubi WHERE klubi.nimi like 'V%' and eesnimi like 'M%' ORDER BY perenimi asc; --4. Leida kõige esimesena alanud partii algamise aeg. SELECT min(Algushetk) FROM partii; --5. Leida partiide mängijad (valge ja must), mis algasid 04. märtsil ajavahemikus 9:00 kuni 11:00. SELECT partii.ID AS "Partii ID", perenimi || ', ' || eesnimi AS "Nimi", isik.ID AS "Isiku ID", must, valge FROM isik, partii WHERE isik.id in (partii.must,partii.valge) AND partii.algushetk between '2005-03-04 09:00:00.000'
lesanne 1------------------------------------------------------------------------------- -- sqlplus scott/tiger@testdata describe kandidaadid insert into kandidaadid values ('Stanislav', 'Tsvetajev', '38609140224', 60, 70, 80); update kandidaadid set eesnimi='Stas' where isikukood=38609140224; select * from kandidaadid where eesnimi = 'Stas'; delete from kandidaadid where eesnimi = 'stas'; lesanne 2------------------------------------------------------------------------------- -- sqlplus scott/tiger@testdata select eesnimi, perenimi, emakeel from kandidaadid where isikukood like '4%' and emakeel >60; select eesnimi, perenimi, to_date(substr(isikukood,2,6),'YYMMDD') as sunniaeg from kandidaadid where to_date(substr(isikukood, 4, 4), 'mmdd')> sysdate order by to_date(substr(isikukood, 4, 4), 'mmdd');
sugu varchar(5) not null, synnipaev date not null, algus datetime not null default current timestamp, viimati datetime default timestamp, CONSTRAINT pk_mina PRIMARY KEY (eesnimi) ); INSERT INTO mina (eesnimi, perenimi, sugu, synnipaev) VALUES ('Juku', 'Mets', 'Mees', '1980-02-04'); grant connect to Sandra identified by 'tere'; grant group to dba; grant membership in group dba to Sandra; grant all on mina to Sandra; SELECT * FROM mina; UPDATE mina SET eesnimi = 'Jri' WHERE eesnimi = 'Juku'; CREATE GLOBAL TEMPORARY TABLE paha (nimi VARCHAR(40) NOT NULL, CONSTRAINT pk_paha PRIMARY KEY (nimi)) ON COMMIT PRESERVE ROWS; INSERT INTO paha (nimi) VALUES ('Mari'); SELECT * FROM paha; create table isik( Id integer not null default autoincrement primary key, Eesnimi varchar (50) not null, Perenimi varchar(50) not null, Isikukood varchar(11), Klubi integer, Unique (eesnimi, perenimi)) create table Klubi( Id integer not null default autoincrement primary key,
1. Loo tabelid RAAMAT ja LUGEJA MySql-is, kui Sa pole seda veel teinud. 2. Sisesta andmed tabelisse RAAMAT vt faili "raamat.txt" ___ 3. Väljasta kogu tabeli RAAMAT andmed. SELECT * FROM `RAAMAT`; 4. Väljasta raamatute pealkirjad, autorid ja ilmumisaastad. SELECT Pealkiri, Autor, Aasta FROM RAAMAT 5. Väljasta nende raamatute pealkirjad, autorid ja ilmumisaastad, mis on ilmunud enne 1950 aastat. Mitu neid on? SELECT Pealkiri, Autor, Aasta FROM RAAMAT WHERE Aasta<1950; 8 6. Väljasta nende raamatute pealkirjad, autorid, ilmumisaastad ja keel, mis on ilmunud peale 1987 aastat. Millistes keeltes on raamatud ilmunud peale 1987 aastat? SELECT Pealkiri, Autor, Aasta, Keel FROM RAAMAT WHERE Aasta>1987; Eesti, jaapani, ja norra 7. Leia kõik 1988 aastal ilmunud raamatud. Väljasta pealkiri ja aasta. Mitu neid on? SELECT Pealkiri, Aasta FROM RAAMAT WHERE Aasta=1988; Neid on 2 8
Attraction of blogs People have always loved to share their thoughts. It is very common that people write those thoughts down, usually into their secret diaries. Nowadays individuals write public blogs, which using has grown quite popular. In my opinion, blogs have become more fashionable than keeping private diaries, because they are public. Everyone has access and a chance to read your own personal views. We live in a modern world, where information is crucial and selling, therefore keeping a blog on the Internet is a big attraction for readers. Furthermore, there are all kinds of journals on the web, for example food sites, where people can find many recipes for different meals. Also, fashion blogs, which can give inspiration if wondering what to wear for some kind of an occasion. Not only are the blogs entertaining, they can also be very helpful and useful. The writers of the blogs get attraction from the amount of readers
When their father dies, the family estate passes to John, and the Dashwood women are left in reduced circumstances. In 18th century womens didn´t have so big role in society as men´s. Only change to get rich by women`s was marriage with the rich man. In movie was mostly talked about high class people. Womens didn´t have the opportunity to take a part in policy. Richer womens had change to hire a butler, so they did´t have to do household job. Women`s free time activities where mostly: music( mostly violin or piano), handcrafting , celebrations and reading. Men`s had a big role in society. Men`s had all the important jobs. Better-paid jobs where : politician, lawyer and to go army and get rich. Men`s free time activities where mostly :hunting, cricket and card games. In this time the people where very polite with each other, especially high-class . They always greeted each other and they where well-educated. The relationship with both side where also good
The first man landed on the Moon in 1969. 27. Alice came to see us in the afternoon. 28. They arrived at six o'clock in the morning. Moodusta: Present Simple (lihtolevik) eitav lause küsimus They make trips during holidays. (When) They do not make trips during holidays. When do they make trips? He makes trips during holidays. He does not make trips. When does he make trips? 1. Children have a good time at the party. (Where) a. Children do not have a good time at the party b. Where do children have a good time? 2. They live in south Estonia. (Where) a. They do not live in south Estonia b. Where do they live? 3. He finishes his workday at four pm. (What time) a. He does not finish his workday at four pm b. What time does he finishes his workday? 4. They close the gates of the park late at night. (When) a
1*. Leia vanima raamatu väljaandmisaasta (väljasta aastaarv). mysql> SELECT MIN(aasta) AS 'vanima raamatu valjastamisaasta' FROM RAAMAT; +---------------------------------+ | vanima raamatu valjastamisaasta | +---------------------------------+ | 1920 | +---------------------------------+ 1 row in set (0.00 sec) 2. Leia vanima raamatu pealkiri, väljaandmise aasta ja autor. mysql> SELECT pealkiri, autor, aasta FROM RAAMAT WHERE aasta=(SELECT MIN(aasta) 'vanima raamatu valjastamisaasta' FROM RAAMAT); +---------------+---------------+-------+ | pealkiri | autor | aasta | +---------------+---------------+-------+ | Tde ja igus | A.H.Tammsaare | 1920 | +---------------+---------------+-------+ 1 row in set (0.00 sec) 3*. Leia kõige uuema raamatu väljaandmisaasta (väljasta aastaarv). mysql> SELECT MAX(aasta) AS 'koige uuema raamatu valjastamisaasta' FROM RAAMAT;
SQL> SPOOL currently spooling to ülesanne_05.lst SQL> --Leidke tabelite yliopilased, koduylesanded, oppeained abil iga tudengi keskmine “punktisaak” koduste tööde eest SQL> SELECT y.eesnimi, y.perenimi, round(avg(k.punktid),1) AS kesk_punkte FROM yliopilased y, koduylesanded k where y.id=k.yliopilase_id GROUP BY y.eesnimi, y.perenimi; EESNIMI PERENIMI KESK_PUNKTE ------------ ------------ ----------- Katrin Kask 5.4 Salme Saar 4.1 Liina Vaher 7.8 Kairi M„nd 6.6 SQL> --Samade tabelite põhjal leidke, mitu tööd on oracle-aine ülesannete kohta saadetud. Grupeerige ülesande numbri kaupa SQL> SELECT k.too_nr, count(k
My ideal home My homeland is so important to me, that if I could choose any place in the world to live in, I'd still choose Estonia. My perfect home can only be in here, where my family and friends are. In Estonia, where are swmaps and pine-wood, sandy beaches, blue sky and big fileds, where are people who i know and the place where i feel in home My perfect home is located outside of Tallinn, in the midst of nature. It is a two story house with a red roof and the house is surrounded by big white fence. Stepping into the garden, you can notice a cobblestoned road, which takes you to the door. Beside the road are planted little red flowers and the garden is covered with green grass. From afar you can see a sauna house, and it has also a red roof
New energy sources Rauno Hermann Scheer Energy law example for 47 countries 6.3% to over 20% Numerous awards including The Right Livelihood Award Renewable energy in world Investments 63 billion USD > 120 billion USD 20062009 Wind energy: 74 000 MW to 135 000 MW Solar energy: 5100 MW to 19 000 MW WHAT ARE THE ALTERNATIVES TO TODAYS SOLAR, WIND AND BIOMASS ENERGY SOURCES? Osmotic power How it works? Pressure created by osmosis powers turbines Where could be used Where fresh and salt water meet (creeks, fjords) Desalination plants Now Worlds first test factory in Norway Tofte (2009) Disadvantages Km2s of membranes needed Norway, Tofte Click to edit Master text styles Second level Third level Fourth level
WHILE @i < @n+1 BEGIN INSERT INTO @FirstTable VALUES (@i) SET @i =@i+1 END SELECT * FROM @FirstTable Tabeli-avaldised (CTE): DECLARE @fibLen AS INT = 10; WITH fibTable (rowNum, prevNum, fibNum) AS ( SELECT 1, 1, 1 UNION ALL SELECT rowNum+1, fibNum, prevNum + fibNum FROM fibTable WHERE rowNum < @fibLen ) SELECT fibNum FROM FibTable; GO Graaf-tabelid: SELECT DISTINCT Person.Name, Post.Content FROM Person, Posted, Post, Likes WHERE MATCH(Person-(Likes)->Post) SELECT Person1.Name, Post.Content, Comments.Comment, Person2.Name FROM Person Person1, Post, Posted, Comments, Person Person2 WHERE MATCH(Person1-(Posted)->Post<-(comments)-Person2) SELECT Person1.Name, Person2.name, Person3
This means that too much ultraviolet radiation now enters the Earth. This is very dangerous because it can cause cancer. Poisonous chemicals also cause acid rain, that destroyes plants, rivers, lakes and buildings. Acid rain can travel thousands of miles, so pollution in one country can become acid rain for another country. So how to avoid the worst? Lets talk about cars, which are the main means of transport in our everyday life, they are useful and take us to the place, where we want to go. But lets be honest, they have also negative aspects. Like heavy traffic in the morning, while you are going to work and in the evening, when you are about to go home. Cars also, like factories, produce poisoned gas in the air. So instead of cars, we should use public transport or a bike, in the name of our enviroment. And what about the factories? Well, we can't remove them from the planet, but they should be built in places, where is less forest and no cities near.
MATEMAATIKA NUMBER(3) VOORKEEL NUMBER(3) EMAKEEL NUMBER(3) 3. Lisage tabelisse enda andmed. SQL> INSERT INTO kandidaadid VALUES(39007283542, 'Marko', 'Reiko', 83, 77, 71); 1 row created. 4. Muutke enda kohta k�ivaid andmeid (n�iteks eksamipunktid). SQL> UPDATE kandidaadid SET id = 39007150154 WHERE eesnimi = 'Marko' AND perenimi = 'Reiko'; 1 row updated. 5. P�rige tabelist enda kohta k�ivad andmed. SQL> SELECT * FROM kandidaadid WHERE id = 39007150154; ID --------------------------------- EESNIMI ------------------------------------------------------------ PERENIMI -------------------------------------------------------------------------------- MATEMAATIKA VOORKEEL EMAKEEL ----------- ---------- ---------- 39007150154 Marko Reiko 83 77 71 6
2 kuldnokk mees Paide 1985 3 Merikotkas mees Pärnu 1982 4 Kurg naine Tartu 1990 5 Luik naine Valga 1988 6 Musträstas naine Tallinn 1992 7 Varblane naine Tallinn 1993 3.Mitme üliõpilase nimi on pikem kui 4 tähte? 4.Mitu naisüliõpilast on Tartust? USE [Virge] GO SELECT [ID] ,[Perenimi] ,[sugu] ,[elukoha_linn] ,[synniaasta] FROM [dbo].[yliopilased_1] where elukoha_linn like 'Tartu' GO 4 Kurg naine Tartu 1990 5.Missugune on meesüliõpilaste keskmine vanus? USE [Virge] GO SELECT [ID] ,[Perenimi] ,[sugu] ,[elukoha_linn] ,[synniaasta] FROM [dbo].[yliopilased_1] where sugu like 'mees' GO 2 kuldnokk mees Paide 1985 3 Merikotkas mees Pärnu 1982 6.Mitu naisüliõpilast on vanemad kui 25 aastat? USE [Virge] GO SELECT [ID] ,[Perenimi] ,[sugu] ,[elukoha_linn] ,[synniaasta] FROM [dbo]
• Adverbs of Manner • Adverbs of Manner tell us the manner or way in which something happens. They answer the question "how?". Adverbs of Manner mainly modify verbs. • He speaks slowly. (How does he speak?) • They helped us cheerfully. (How did they help us?) • James Bond drives his cars fast. (How does James Bond drive his cars?) • Adverbs of Place • Adverbs of Place tell us the place where something happens. They answer the question "where?". Adverbs of Place mainly modifyverbs. • Please sit here. (Where should I sit?) • They looked everywhere. (Where did they look?) • Two cars were parked outside. (Where were two cars parked?) • Adverbs of Time • Adverbs of Time tell us something about the time that something happens. Adverbs of Time mainly modify verbs. • They can answer the question "when?": • He came yesterday. (When did he come?) • I want it now. (When do I want it?)
Many countries have ruled Estonia. 3 Rooma villas olid keskküte ja mosaiikpõrandad. A Roman villa had central heating and mosaic floors. 4 Roomlastel ei õnnestunud Sotimaad vallutada. The Romans didn´t manage to conquer Scotland. 5 See imeerium on eksisteerinud umbes 400 aastat. This empire existed foir about 400 years. 6 kohalikud elanikud inhabitants 7 lossivaremed ruins of a castle 8 restaureeritud mõis a restored manor house 2 Use the words who, whose, which or where to complete the sentences. 1 This is the house where I grew up. 2 The film which we saw yesterday was about a cowgirl called Calamity Jane. 3 The boy whose mother we met in Regent Street is my cousin. 4 This is the cafe where my mother has a cup of coffee after work. 5 Our car, which we bought 2 years ago, is a dark blue Mercedes. 6 The man who lives next door is a famous writer. 7 Where is the book which you gave me as a birthday present last year?
3.) A question can also begin with a question word. Notice that the word order changes * She is dancing. - What is she dancing? NB! Who did Peter phone? (Subject is Peter) Kellele Peeter helistas? Who phoned Peter? (Subject is who) Kes helistas Peetrile? REPORTED QUESTIONS When we ask for information, we often say Do you know...?/ Could you tell me?. If you begin a question like this, the word order is different from a simple question Compare: Where has Tom gone? But Do you know where Tom has gone? * What time is it? Do you know what time it is? *Who is that woman? I don't know who that woman is. *Where can I find Linda? Can you tell me where I can find Linda? * How much will it cost? Have you any idea how much it will cost? Be careful with do/does/did questions: *What time does the film begin? Do you know what time the film begins? *What do you mean? Please explain what you mean. *Why did Ann leave early? I wonder why Ann left early.
Present Simple Past Simple Present Continuous Past Continuous Going To Future I pv IIpv I AM I was/where +ing I am + going to + I pv (he,she,it) I pv +S (õpiku taga! ED) He/She/it is + ing He/she/is was +ing He/she/it is+ going to +I pv We /they ARE +ING You/we/they were +ing You/we/they are+ going to +I Eitus: Eitus: Eitus: Eitus: Eitus:
REPORTED SPEECH 1. Kui saatelause on olevikus, jäävad kaudkõnes ajavormid samaks. Muutuvad ainult asesõnad ja küsilausetes ka sõnajärg. He says,"I'm fifteen years old." He says he's fifteen years old. He asks me," Where did you live two years ago?" He asks me where I lived two years ago. 2. Kui saatelause on minevikus, muutuvad kaudkõnes lisaks asesõnadele ka asjavormid, mis nihkuvad mineviku suunas, ja ajamäärussõnad (today, this week, yesterday, last year) ning näitavad asesõnad (this, these). Küsilausetes lisanduvad kõigile neile muutustele ka veel ka sõnajärje muutused. Seega on küsilauseid minevikus kõige raskem kaudkõnesse panna. He said to me,"I was at home yesterday."
storm was so intense, it made hurricane Irma look like a sneeze. It must have been the loudest thunderstorm I have ever heard and the rain like someone was pouring water from a giant bucket. I barely made it to the shelter, that my dad built a few years ago. It was a safe place to hide while hurricanes and thunderstorms were bullying. The room was equipped with all the necessary things food, water, batteries, flashlights, warm clothes, etc. But to my surprise, I was the first one there. Where were mum and dad? Where was my younger sister? I tried to remember where I saw them last. I couldn't think straight, I was overwhelmed with worry. I heard someone banging on the hatch. I opened it with lightning speed and I saw my sister standing there. "Why are you standing there? Come in, quickly!" I demanded. "Where were you? Where are mum and dad?" I asked anxiously. "I was in the toilet and suddenly I felt the house shaking. I called for mummy but nobody was there
to_date('20150101', 'YYYYMMDD')); INSERT INTO VAEOSAS_OLEMINE (ID, ISIK_ID, VAEOSA_ID, ROLL, ALATES) VALUES (14, 6, 4, 'major', to_date('20150101', 'YYYYMMDD')); INSERT INTO VAEOSAS_OLEMINE (ID, ISIK_ID, VAEOSA_ID, ROLL, ALATES) VALUES (15, 5, 9, 'sanitar', to_date('20050101', 'YYYYMMDD')); Tulemus 4. Tabelis olevate kirjete andmete muutmine a) Muudan andmeid ühes kirjes - Mari Maasika perenimi muutus abielutõttu UPDATE ISIK SET PERENIMI = 'Mustikas' WHERE ISIKUKOOD = '49204136581'; Tulemus b) Muudan andmeid mitmes kirjes - rolli "sanitar" muutuvad "arst"-iks UPDATE VAEOSAS_OLEMINE SET ROLL = 'arst' WHERE ROLL = 'sanitar'; Tulemus c) Muudan korraga andmeid ühe tabeli kõigis kirjetes - tabelis VAEOSAS_OLEMINE kommentaar = Eesti Vabariigi väeosa UPDATE VAEOSA SET KOMMENTAAR = 'väeosa'; Tulemus 5. Tabelis olevate kirjete kustutamine
3) it counts the number of distinct IDs in the resulting set, thusly solving the problem CREATE OR REPLACE FUNCTION joint_buyers_text(integer, integer) RETURNS text AS $BODY$ DECLARE bookX ALIAS FOR $1; bookY ALIAS FOR $2; count integer; BEGIN SELECT INTO count COUNT(DISTINCT person_id) FROM ( SELECT p.person_id FROM person_book AS p INNER JOIN (SELECT person_id FROM person_book where book_id=bookY) AS b ON p.person_id=b.person_id WHERE p.book_id=bookX ) al; RETURN "Books "||bookX||"and"||bookY||" have been purchased together by"||count||" people"; END; $BODY$ LANGUAGE plpgsql VOLATILE SECURITY DEFINER Example function call to test the function: SELECT joint_buyers_text(0, 9) as answer Result as presented in pgAdmin III: Task 2:
The Giant ´s Causeway 1. What does the legend say who made it? A giant 2. What does it look like? Huge stairs 3. According to legend, why was it made? To cross the sea 4. What is it made of? Stones 5. how high are the tallest stones? 12 metres Loch Ness 1. Where is it? In Scottland 2. Why does it have name like this? A monster ´s name ( Ness ) Loch means lake 3. How deep is the deepest point? 266 metres 4. Loch Ness is having one island, what ´s it ´s name? Cherry 5. What do people every year organize in Loch Ness? Running competition Stonehenge 1. When did people build it? About 5500 years ago 2. How did people transport those stones? With rafts 3. What do people think why is it built? For astrology 4
Abbey Lee Kershaw Chilhood · Fashion bohemian Abbey Lee Kershaw (also known as Abbey Lee) was born on June 12, 1987, in Melbourne, Australia. · She says she had an idyllic childhood, growing up in a great neighborhood where she had plenty of friends who lived near her. · Abbey says her school was fantastic because it was so culturally diverse--there were 150 kids in her school and 42 different nationalities. Career · Abbey was discovered by Kathy Ward from Chic just 100 meters away from her house, at the beach where she went every day to hang out. · Abbey modeled throughout her last year of high school and won the Australian Girlfriend CoverGirl Model Search
next the following week/year week/year NT: He said: ,,I am coming to the party today." --- He said (that) he was coming to the party that day. · Questions.In direct speech the the questions starts with do, does, did they do not appear in reported speech. In reported speech they always start with if or whether. NT: Mary asks me: "Do you like tennis?" --- Mary asks me if/whether I like tennis. In reported speech the questions which start with what,who,where,why,how,when they stay in the reported speech sentence. NT: She asked him: "How old are you?" --- She asked him how old he was. EXERCISE. Rewrite the sentences in reported speech. Change pronouns and time expressions where necessary. 0. She said, "I am reading." She said that ... (she was reading) (Present Progressive becomes Past Progressive.) 1.They said, "We are busy." They said that.... (they were busy.) (Simple Present becomes Simple Past) 2.He said, "I know a better restaurant."
In the future i would like to have a perfect family. My perfect family would be composed by children who are healthyminded and a man who is a good father and right for our family. Also, we would have a house that we could live in comfortably. The house would be just out of town, where nature thrives and also have a beautiful view of the coast. In the house there could be living room where the children can play different games when their friends would visit us. I would prefer to have a big garden for hosting bbq and taking sunbaths in the summer. I would llike to have 2 children, and i dont mind whether they are boys or girls because the most important thing for my children is that they are healthy. I would like my children to be courteous and have lots of hobbys. The man I marry should love his family. He would never have another lover and hurt me and my children.
annaabi.ee 
