Order, Search, and Sort MySQL Data

When you query a MySQL database, you can sort the results by any field in an ascending or descending order just by adding ORDER BY at the end of your query. You use ORDER BY field_name ASC for an ascending sort (which is the default) or ORDER BY field_name DESC for a descending sort. You can use an ORDER BY clause in a SELECT statement, SELECT LIMIT or DELETE LIMIT statement. For example: SELECT * FROM addressORDER BY name ASC; The code above retrieves data from an address book and sorts the results by the persons name in an ascending fashion. SELECT email FROM addressORDER BY email DESC; This code selects only the email addresses  and lists them in descending order. Note: If you dont use an ASC or DESC modifier in the ORDER BY clause, the data is sorted by expression in ascending order, which is the same as specifying ORDER BY expression ASC.

The Movie O F. A Beautiful Mind - 1000 Words

The film o f A Beautiful Mind is a dramatization of the life of John Forbes Nash; that was released in 2001. The character of Mr. Nash is portrayed by the actor Russell Crowe, and the film was directed by Ron Howard. The movie is based on the true story of a brilliant mathematics student from West Virginia who won a distinguished scholarship to attend Princeton University. The film begins in n September of 1947, when he began to attend the University of Princeton; where he studied mathematics and contributed to the field. His first encounter with his hallucination was when he first felt rejected by his classmates, especially by Michael Hansen; another brilliant student. John felt intimidated by Hansen which caused him to feel isolated from everyone. He preferred to spend most of his time trying to discover a new original idea of the theory of government dynamic. John felt that it was the only way he was going to be accepted and recognized by society. John’s lack of focus on sc hool made him become frustrated and resulted into the development of one of the first imaginary characters, Charles Herman, his roommate which is played by the actor Paul Bettany. Herman was studying English Literature and became John’s best friend. John’s social situation was characterized by his strong anxiety and excessive self-consciousness in everyday circumstances. His fear of judging or to be humiliated interfered with his work, social life, school, and other activities. For example, John onlyShow MoreRelatedMessage Appeals Used in Advertising1303 Words   |  6 Pagesby focusing on the importance of comfort, better attention spans whilst sitting straight, etc may induce the consumer to purchase a study table for the household. Fear Appeal: The Fear appeal is used by advertisers to induce fear in the consumer’s minds. Most advertisements that use the fear appeal show the pitfalls that the consumers might face, if they do not use the product. If one does not use a Study Table to study one might not be comfortable, hence one’s concentration levels would drop andRead MoreUnpacking The Standards : Annotated Bibliography3693 Words   |  15 Pagessomeone or something. Any concept or idea that the author uses to tell the story. The means of conveying an attitude. A feeling, emotional state, or disposition of mind. A person in a narrative work of art. The historical moment in time and geographic location in which a story takes place. The main events of a play, novel, movie, or similar work, devised and presented by the writer as an interrelated sequence. A image illustrating in a book. Person who writes the story or book Main partRead MoreLegally Blonde Film Analysis2165 Words   |  9 PagesDescribe the movie you picked and why you picked it: The movie I chose, is titled Legally Blonde, starring Reese Witherspoon. The movie follows the story of Elle Woods, who seems to have it all. With her stunning blonde hair, sorority sisters, and her rich, senator aspiring boyfriend, she’s sure to have the perfect life. Elle’s world gets turned upside down when her boyfriend, Warner Huntington III, leaves her in the dust for Harvard law school in an attempt to find a â€Å"Jackie O† type of woman. InsteadRead MoreCurriculum For English Learners Beginner Level 210689 Words   |  43 PagesTEACHER OF TWO MONKEYS TRAVEL CURRICULUM FOR ENGLISH LEARNERS BEGINNER LEVEL 2 Written and Prepared by CECILIA LABJATA-HOBBS WELCOME Curriculum for English Learners Beginner Level 2, is designed with everyday English usage in mind. It is a curriculum that focuses on encouraging the learners to be confident in expressing themselves in English. This curriculum uses a fun approach to basic conversational English, stressing communication in a variety of situations, by introducingRead MoreAn Argument Against Auteur Theory.2750 Words   |  11 Pagesattributes much of the success of his films to his utilization of Freudian theory. ..film is the best medium in the world for a Freudian esthetic, because the unconscious predates language; it seems to deal with predominantly visual images, your conscious mind relaxes because of your surroundings, breaking down some of the barriers to the unconscious2. If these words were uttered by Luis Bunuel, or Orson Welles, they would no doubt be heralded as that of a genius, yet from the mouth of Roger Corman, theyRead MoreEssay about Analysis of Good Will Hunting4243 Words   |  17 PagesAbstract This paper will discuss this students perception, study and analysis of the character Will Hunting, in the movie Good Will Hunting. (Affleck and Damon, 1997) It will share the results and conclusions about the character of Will Hunting reached by this author, citing the methods and theories used to reach said results and conclusions. The report will provide a brief overview of the character, a cultural description of the character, discuss the characters personality development fromRead MoreEssay about Analysis of A Clockwork Orange2423 Words   |  10 Pagesrepetition, and laced with word play. Irony is used extensively A Clockwork Orange. One of the most repeated and significant examples of irony is in Alexs description of violence. Prior to his treatment, he refers any form of violence as beautiful. After he hits Dim in the face, Alex says Dim is singing blood to make up for his vulgarity (Burgess, Clockwork 28). However, Alex refers to things most people regard as beneficial--education, religion, and rational thought--as undesirable andRead MoreIntroduction : How ve He Do That?10829 Words   |  44 Pagesd; (D) And every fair from fair sometime declines, (C) By chance or nature s changing course untrimm d; (D) But thy eternal summer shall not fade (E) Nor lose possession of that fair thou owest; (F) Nor shall Death brag thou wander st in his shade, (E) When in eternal lines to time thou growest: (F) So long as men can breathe or eyes can see, (G) So long lives this and this gives life to thee. (G) As noted by the use of rhythm and unique vocabulary, this is without a doubt a Shakespearean sonnetRead MoreTruth in media Essay2752 Words   |  12 Pagesprovocative near the sea, and also along a rock wall. The article refers to Jessica Alba being a mind-blowing beauty, also, a mother, and a business woman With the pictures of Alba being displayed as a sex symbol, there is no correlation with her being a mother or business woman. The pictures display of Alba can increase the addiction to pornography in men, since the article has nothing to do with her new movie, or the fact she is a mother. After looking at the pictures you can tell that they have beenRead MoreCultivation Theory7009 Words   |  29 Pageseffects of television to society. This conduct of research is mainly carried out in America to analyze the audience there who are mainly categorized as couch potatoes. Cultivation theory also shows how people react after watching a particular program/movie on the television because cultivation theory is mainly based on how the television cultivates or moulds the mindset of society. It is also said that those who watch four or more hours a day are labeled heavy television viewers and those who view less

National Boundaries Make Little Geographical or Economic Sense Nowadays free essay sample

National boundaries have long been in place in human history, with the main intention of using them to control or restrict movement of people, commodities, capital or information into or out of a country. However, as the world steps into the 21st century and becomes more globalised and interconnected, many start to wonder if the power that the state once held is now diminished by the forces of globalisation. Some even question the significance of national borders in today’s world as they become increasingly permeable due to intensified world-wide connections and time- space compression. In order to judge if this claim is true, several key factors have to be taken into consideration. Do time-space compression and technological advancement inevitably bring about effects that weaken the position of a state geographically and economically? Do supranational bodies such as the United Nations and ASEAN (Association of Southeast Asian Nations) play a part in blurring the need for such borders? Will national pride and government control override all these other factors, invalidating the claim that national boundaries are no longer essential? After much consideration and deliberation, I strongly believe that the importance of national borders has been diminished to a large extent but there are other factors such as national security that will still uphold the significance of having national boundaries. With the emerging force of globalisation, countries all around the world have grown to be more independent, consequently resulting in an inevitable increase in economic integration via trade, foreign investments and immigration. Statistics from the United Nations Conference on Trade and Development have confirmed this phenomenon: foreign direct investment, for example, grew by an average annual rate of 34 percent in the 1980s and early 1990s. This trend continued throughout the 1990s, facilitated by the pervasive tendency towards the removal of barriers to capital flows. Also in 2004, a total of US$47881 million flowed seamlessly around Asian countries as foreign direct investment. Furthermore, the number of multinational companies outsourcing and off shoring has also been sky-rocketing over these years. Evidently, the dramatic increase in the scale and reach such companies and transnational flows of capital have undermined the ability of the state to regulate economic activities across borders over the past three decades. On the other hand, from a geographical point of view, time-space shrinking technologies and modernisation in transportation have allowed the easy movement of people from one country to another. Technology has shortened travel time from months to just mere hours and this has inevitably resulted in the increased mobility of people. A simple illustration would be the brain-drain problem faced by Singapore. It is not uncommon to hear people at all levels of the Singapore society complain about the outward flow of talents to global cities such as New York and London. With so much freedom and choice provided for immigration, people who were originally citizens of one country can easily switch nationalities or even take up multiple permanent residencies, resulting in national boundaries losing their geographical importance. Besides having a homogenising economic impact on the world, globalisation has also brought about the establishment of supranational bodies, thus affecting states politically. More often than not, such supranational institutions are often blamed for eroding the traditional sovereign authority of the world’s approximately two hundred states. Such bodies like the International Monetary Fund and World Bank have aggravated the problem that borders no longer function as parameters in which citizenship rights are exercised. The democratic principles which assume that citizens participate in the decisions which affect their lives, and that governments are accountable to those they govern, are increasingly difficult to sustain in circumstances where so many decisions affecting a state and its population occur beyond its borders. A perfect example would be the Structural Adjustment Programmes initiated by the IMF. The conditionality attached to these programmes is a clear example of policies within the borders of a state being decisively influenced by an outside agency, over which citizens have no rights. The increased internationalisation of political decision-making in supranational forums only magnifies this de facto loss of citizenship rights, creating a sharp disjuncture between the principles and practices of democratic, state-based citizenship, which will in turn result in a devastating geographical impact on a country. Champions of the opposite camp often assert that national borders still have a great influence geographically and economically today, especially when a country is dealing with its national security or identity. An example would be the â€Å"Total Defence Scheme† carried out by various nations like Sweden, Switzerland, Denmark and Singapore to deal with external threats like terrorism and economic crises. In Sweden, this system comprises mainly military and civil defence to defend Sweden against armed attacks and strengthen the Swedish society in times of severe peacetime emergencies. National identity and pride can also be demonstrated even more clearly in territorial disputes and this can be epitomised through the twenty nine-year dispute between Malaysia and Singapore over Pedra Branca. The amount of resources and manpower spent on such disputes undoubtedly prove that national borders are far from trivial. Although this may seem to be an irrefutable claim, these critics fail to see that such disputes over national borders are merely dealt by government agencies and they have little effect on society itself. Moreover, critics may also argue that government intervention can have significant control over cashless transactions made between countries. In order to protect a country’s own economy, governments may impose tariffs on other countries or even go to the extreme of enforcing trade embargos. Such an assertion may be true but it overlooks the glaring fact of the rising power of trading blocs. With about thirty trading blocs today, the power of the state has been greatly crippled. For example, the establishment of the North American Free Trade Agreement between USA, Canada and Mexico and the Association of Southeast Asian Nations Free Trade Agreement (ASEAN FTA) have eliminated trade barriers and increased borderless investment opportunities between these countries. The fact that ASEAN FTA has generated a combined Gross Domestic Product growth of 5. % annually since 2004 signifies that such borderless transactions are now starting to be in favour. Moreover, besides affecting countries economically, trading blocs such as the European Union have also changed the geographical dynamics of a country as countries in the EU are now politically integrated, following the same system of governance. All in all, it is obvious that the significance that national boundaries once held is starting to deteriorate gradually overtime as countries progress towards a more integrated world. However it may be incorrect to hastily conclude that that the strength of state borders is now decreasing as the world heads towards globalisation since there are still aspects where national boundaries are highly essential like in the case of national security. Nonetheless I can say with no fear of contradiction that in the long run, the position and authority of national boundaries may be threatened by globalisation, thereby causing national borders to have little geographical or economic sense in the future.

Natural Disaster Hazard Assessment Essay Example

Natural Disaster Hazard Assessment Essay Hazard Assessment for Memphis, Tennessee Environmental Geology Hazard Assessment for Memphis, Tennessee A natural disaster is defined as any event or force of nature that has catastrophic consequences (â€Å"natural disaster†). The only reason that these events are considered to have catastrophic consequences is because people are negatively affected by these natural events. If people were not present during these events, they would not be considered catastrophic. The more people affected means the event would be considered more catastrophic. Tennessee is the 17th most populated state, with approximately 6. million residents (Infoplease. com). Within the state, Shelby county covers the most area, (755 square miles), and is also the most populated county, with approximately 927,644 people residing there (Infoplease. com). Shelby county includes the city of Memphis. Memphis is the most populated city within Tennessee with at least 645,000 residents (Infoplease. com). I have atta ched several maps in order to see different parts of the land. Map I shows where the county lines are located within Tennessee. You can also see where Memphis is located within the county. Map II shows the elevation levels of the state. As you can see in that map, Memphis is located within the lowest elevation levels of the state. Map III shows the rivers that run throughout the state. The main river that runs between the Tennessee, Arkansas, and Missouri borders is the Mississippi River. There are several natural disasters that I would consider to be threats to the Memphis area. One natural disaster that I would consider to be a concern to Memphis would be an earthquake. According to the United States Geological Survey, (USGS), there is an approximately six percent chance that there will be a major earthquake within 50 kilometers of We will write a custom essay sample on Natural Disaster Hazard Assessment specifically for you for only $16.38 $13.9/page Order now We will write a custom essay sample on Natural Disaster Hazard Assessment specifically for you FOR ONLY $16.38 $13.9/page Hire Writer We will write a custom essay sample on Natural Disaster Hazard Assessment specifically for you FOR ONLY $16.38 $13.9/page Hire Writer Memphis in the next 50 years (Homefacts. com). The last earthquakes that had magnitudes of five were in 1976 and 1991 (Homefacts. com). The earthquake recorded in 1976 was approximately 40 miles away from Memphis. Looking at the sources found, I see that Tennessee has had its fair share of earthquakes, so I would say that another earthquake occurring in the area should be a concern of the citizens and government officials. â€Å"There is a broad agreement in the scientific community that a continuing concern exists for a major destructive earthquake in the New Madrid seismic zone. Many structures in Memphis, Tenn. and other communities in the central Mississippi River Valley region are vulnerable and at risk for severe ground shaking. † (USGS. gov). The New Madrid Earthquake of 1812 was one of the most significant events in U. S. history. Topographic changes were noted over an area of 75,000 to 130,000 square kilometers, with the total area shaken being at least five million s quare kilometers (USGS. gov). Back then, the damage was minimal because of sparse population. Nowadays, an earthquake that severe could result in â€Å"great loss of life and property damage in the billions of dollars† (Cusec. rg). The fact that Memphis is the most populated city in the state, a small earthquake could cause a significant amount of damage. â€Å"By learning about the potential earthquake hazards in your area and by taking certain preparedness measures now, you can increase your chances of surviving an earthquake and minimize its dangerous and damaging impacts† (Cusec. org). There are many organizations that Memphis has in order to help citizens learn how to prepare for these catastrophic events, and what to do in order to survive. One organization is the Radio Amateur Civil Emergency Service (R. A. C. E. S. ), which is a volunteer communications group that assists the Shelby county area. R. A. C. E. S. provides emergency personnel that can help with communications during local, regional, or national emergency/disaster events (Cityofmemphis. org). Another organization that provides help during emergency situations is the Memphis/Shelby County Emergency Management Agency (EMA). The EMA helps local, state, and federal agencies with response to disasters that requires a multi-agency/multi-jurisdictional response. The EMA has satellite links with the National Weather Service that activates sirens in order to warn the residents of multiple cities, including Memphis (Cityofmemphis. org). There are also things that the citizens and homeowners could do in order to minimize the damage during earthquake. Earthquake drills are a great way to help enforce the importance of preparedness, and to prevent panic and injury during an earthquake. Families should have emergency plans that lay out where everyone is going to be and where to reunite with one another. Keep a flashlight and a batterypowered radio in the home. Place large or heavy objects on lower shelves, and fasten the shelves to walls. And lastly, have a seven to ten day supply of food and water (Cusec. org). You can never be too prepared for any natural disaster, so being safe is better than being sorry. Not all natural disasters are threats to Memphis. Volcanoes are an example of a natural disaster that is not a threat to the Memphis area. There are no known volcanoes in the area that would cause any kind of harm to the residents of Memphis. Historically, there have not been any known volcanoes in the area either. Memphis is not located on any fault boundaries, so I would think that there would no volcanoes forming in the area any time in the near future. Hurricanes are a little more of a concern for Memphis. The western area of the state has the possibility of being affected by the end of certain storms. Hurricane Katrina is an example of this situation in which Memphis can be affected by storms not necessarily in the direct area. When Hurricane Katrina hit the U. S. in 2005, multiple counties in Tennessee were evacuated; Shelby County was one of those counties (Fema. gov). I would consider Memphis to be slightly concern about hurricanes occurring in the area, especially since the city is located at a low elevation. The lower elevation would be more susceptible to flooding. The government should have adequate warning of the hurricane, since it would most likely be coming from the Gulf of Mexico. I would also expect that the citizens would be prepared for hurricanes, since they are used to flooding situations. Tornadoes, I feel, are more of a concern than hurricanes. There are many more tornadoes in the middle of the state then there are on the outskirts. Tornadoes are more likely to strike open plains rather than in an urban area, like Memphis. â€Å"The reality is, very few tornadoes ever touch down in the city of Memphis†¦.. Nevertheless, tornadoes can and have struck within the city† (About. com). There have been numerous tornadoes that have affected Shelby county, but not nearly as many as the middle of the state. The last one that affected Shelby County, and had a high death count was in 1987, with at least 120 deaths (NWS Memphis Forecast Area Tornado Database). There have since been tornadoes that have caused deaths, hich is not surprising considering the amount of people that live in the city. With all the tornadoes that have gone through the county, there has always been a significant amount of damage. That also is understandable since there are a lot of buildings in the city. There have also been plenty of tornado warnings for the state, but not all of them affecting Shelby County. The last tornado warning that included Shelby County was on May 9, 2011. In order to be prepared for a tornado, there are several things we could do. First of all, avoid windows and seek shelter in the center-most room on the lowest floor possible. Use your hands and arms to protect yourself from falling debris. Also, keep some sort of identification on you at all times in case you are hurt or disoriented (About. com). Keeping identification on you is a good idea for every natural disaster. It will help emergency personnel identify who you are and hopefully get you back with your family. Tsunamis are another type of natural disaster that is not a concern for Memphis. There have been no known tsunamis recorded for Memphis. I do not think that there will be any future tsunamis in Memphis because there is no ocean or large body of water located near Memphis. The Mississippi River is near Memphis, but the river does not create waves that would be large enough to create a seismic wave. Even though tsunamis are not a threat to the city, flooding is a huge concern for the city. The Mississippi River is right near the city, so that would be a reason as to why the area floods frequently. The city is also at a low elevation, which is another reason as to why the area floods frequently. There is currently an active flood warning in effective right now (Fema. gov). Last year, there was flood that occurred in the beginning of May. The Mississippi River was supposed to rise to a record level of 48 feet, with 48. 7 being the record crest in 1937. More than 1,300 homes were ordered to evacuate and nearly 400 people were living in shelters. According to an article on abcnews. com, the most extensive damage occurred in Memphis, where â€Å"entire neighborhoods have been swallowed by the water and vehicles completely submerged† (Tanglao, â€Å"Memphis Flooding†). Since this obviously happens frequently, the citizens and government have ideas of what the levees can hold, and what the river’s maximum water level is. To prepare for flooding situations, there are certain things the government should tell their residents in order to make sure they are safe. They must send out warnings letting people know when and if the water level is high enough to go over the lands limits. In Memphis, the government should be able to accurately know when and if the Mississippi River has reached its maximum, and if people should evacuate their homes. As a resident, you should also be aware of what is going on in your community and know about the town’s emergency plans. You should also have sump pumps with back-up power in order to prevent contamination of the flooded water. Turn off all utilities at the main power switch in order to prevent electrocution. Fill bathtubs, sinks, and soda bottles with clean water, so you have water to drink that is not contaminated. You should also have water bottles and a food supply that will last a couple of days (Bt. cdc. gov). On the opposite end of the spectrum, wildfires are another example of a non-threat to Memphis. There are no forests in Memphis because it is a highly urban area with lots of people and buildings. The last wildfire reported in Memphis was in 1952, when there was a serious drought (Tnema. org). Even though there was that wildfire many years ago, I do not think that there is a serious threat to Memphis for another wildfire. Lastly, I also think that there is not a threat for extreme winter conditions to occur in Memphis. The last warning for some sort of winter conditions for Shelby County was in February 1992 (Fema. gov). Even though that was not too long ago, I still feel like there is not a huge concern for extreme winter conditions to occur any time soon again. Since Memphis is further south, they do not really get harsh winters like we do here in Pennsylvania. Memphis Tennessee has its fair share of natural disasters. They have to be concerned about earthquakes, floods, and tornadoes the most, while extreme winter conditions, volcanoes, and tsunamis the least concerned about. Every place on the Earth has to be concerned with natural disasters. Humans make the disasters a lot worse than they actually are, but there is nobody else to blame but ourselves. We get in the way of nature, and have to pay the consequences some way or another. Map I Map II Map III Works Cited Centers for Disease Control and Prevention. Natural Disasters Severe Weather. Web. 12 April 2012. Central United States Earthquake Consortium. Earthquake Safety. Web. 12 April 2012. City of Memphis. Emergency Management Agency. 2003-2011. Web. 12 April 2012. Federal Emergency Management Agency. Tennessee Disaster History. 26 March 2012. Web. 12 April 2012. â€Å"Memphis Earthquake Information. † Homefacts. com. 2012. Web. 12 April 2012. â€Å"Natural Disaster. † Dictionary. com. Web. NWS Memphis Forecast Area Tornado Database. Web. 12 April 2012. Tanglao, Leezel. Memphis Flooding: Mississippi River Nears Record Highs. † AbcNews. com. 9 May 2011. Web. 12 April 2012. â€Å"Tennessee. † Information Please Database. Pearson Education, 2011. Web. 12 April 2012. Tennessee Emergency Management Agency. Wildfire. Web. 12 April 2012. â€Å"Tornadoes in Memphis: What to expect and how to stay safe. † About. com. The New York Times Co mpany, 4 April 2011. Web. 12 April 2012. United States Geological Survey. Earthquake Hazard in the New Madrid Seismic Zone Remains a Concern. 3 August 2009. Web. 12 April 2012. United States Geological Survey. Tennessee: Earthquake History. 21 October 2009. Web. 12 April 2012.